Can someone help me with this optionbutton quesion?

DUGG · Mar 4th, 2002, 11:10 AM

Im trying to make my dropdown list specific to only the optionbutton selected. I have each optionbutton in a different row (6 - 16)and when that button is selected i want the same dropdown menu to affect only a certain cell in that row. Im a newbie with VBA, but learning fast(slowly)

Any help would be greatly appreciated.

Ian Mac · Mar 4th, 2002, 01:48 PM

Quote:

On 2002-03-04 10:10, DUGG wrote:
Im trying to make my dropdown list specific to only the optionbutton selected. I have each optionbutton in a different row (6 - 16)and when that button is selected i want the same dropdown menu to affect only a certain cell in that row. Im a newbie with VBA, but learning fast(slowly)

Any help would be greatly appreciated.

This is quite a complicated one, I have just set up a small starting point for you to play with, if you'd like it just e-mail me.

Dave Hawley · Mar 4th, 2002, 02:04 PM

Hi

I replied to this before, not sure if you got it or not. I have a workbook download example of this here:

http://www.ozgrid.com/download/default.htm
The one you want is at the bottom called:
ChangingCombo.zip

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 11:10 AM	#1
DUGG New Member Join Date: Mar 2002 Posts: 2	Im trying to make my dropdown list specific to only the optionbutton selected. I have each optionbutton in a different row (6 - 16)and when that button is selected i want the same dropdown menu to affect only a certain cell in that row. Im a newbie with VBA, but learning fast(slowly) Any help would be greatly appreciated.

Mar 4th, 2002, 02:04 PM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi I replied to this before, not sure if you got it or not. I have a workbook download example of this here: http://www.ozgrid.com/download/default.htm The one you want is at the bottom called: ChangingCombo.zip