I have a combobox that has 8 listed items lets say 1-8. I would like
where if you choose 3 in the combobox cell D6 changes to 3 then if I
choose 6 cell chooses 6 and so, whatever number i choose changes D6 to
equal that value. Also I have a chart macro attached to each number
whereas I choose 3 a chart will generate and a different chart will
generate the same for the rest of the numbers. Any help.

Ryan

One way is to double click the combo box while in design mode and put this
between the two lines of code that appear there:

The final product should be:

Private Sub ComboBox1_Click()
ActiveSheet.Range("D6") = ComboBox1.Value
End Sub

There are a couple of other ways to do it, but this is as good as the others.

"(E-Mail Removed)" wrote:

> I have a combobox that has 8 listed items lets say 1-8. I would like
> where if you choose 3 in the combobox cell D6 changes to 3 then if I
> choose 6 cell chooses 6 and so, whatever number i choose changes D6 to
> equal that value. Also I have a chart macro attached to each number
> whereas I choose 3 a chart will generate and a different chart will
> generate the same for the rest of the numbers. Any help.
>
> Ryan
>

On Dec 17, 4:09 pm, JLGWhiz <JLGW...@discussions.microsoft.com> wrote:
> One way is to double click the combo box while in design mode and put this
> between the two lines of code that appear there:
>
> The final product should be:
>
> Private Sub ComboBox1_Click()
> ActiveSheet.Range("D6") = ComboBox1.Value
> End Sub
>
> There are a couple of other ways to do it, but this is as good as the others.
>
> "ryan.fitzpatri...@safeway.com" wrote:
> > I have a combobox that has 8 listed items lets say 1-8. I would like
> > where if you choose 3 in the combobox cell D6 changes to 3 then if I
> > choose 6 cell chooses 6 and so, whatever number i choose changes D6 to
> > equal that value. Also I have a chart macro attached to each number
> > whereas I choose 3 a chart will generate and a different chart will
> > generate the same for the rest of the numbers. Any help.
>
> > Ryan

How do I link that code to the combobox? Whats the difference between
private sub and sub? because private sub doesnt come up when I assign
a macro to the combobox but sub does?