Hello,
I know there is a fairly simple solution to this, but it has eluded m
so far.
Using VBA code, I'm trying to pass a user selected value from Combobox
on Sheet2("Step 2") to a Combobox1 on sheet3("Step 3").
Both comboboxes are filled by the same range from a sheet calle
SpeciesList (A2:A30).
I've tried this:
Public Sub ComboBox1_Click()
Sheets("Step 2").ComboBox1.Value = Sheets("Step 3").ComboBox1.Value
End Sub
or this:
Public Sub ComboBox1_Change()
Sheets("Step 2").ComboBox1.Value = Sheets("Step 3").ComboBox1.Value
End sub
The code works once, (i.e. it will pass the value selected on sheet
combobox to the combobox on sheet 3) then it gets locked on a specifi
selection. How can I loop my code so that it changes the valu
everytime a new value is selected.
Thanks for any help I can ge
--
Message posted from
http://www.ExcelForum.com