Combobox help.....really easy I imagine

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryan.fitzpatrick3@safeway.com - 17 Dec 2007 22:51 GMT

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

Reply to this Message

JLGWhiz - 18 Dec 2007 00:09 GMT

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.

> 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
[quoted text clipped - 4 lines]
>
> Ryan

Reply to this Message

ryan.fitzpatrick3@safeway.com - 18 Dec 2007 20:41 GMT

> 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:
[quoted text clipped - 16 lines]
>
> > 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?

Reply to this Message