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

You say "from Combobox1 on Sheet2("Step 2") to a Combobox1 on sheet3("Step
3")." but your code would pass the value in the opposite direction.


"Excel-erate2004 " wrote in
message ...
Hello,

I know there is a fairly simple solution to this, but it has eluded me
so far.

Using VBA code, I'm trying to pass a user selected value from Combobox1
on Sheet2("Step 2") to a Combobox1 on sheet3("Step 3").

Both comboboxes are filled by the same range from a sheet called
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 sheet2
combobox to the combobox on sheet 3) then it gets locked on a specific
selection. How can I loop my code so that it changes the value
everytime a new value is selected.


Thanks for any help I can get


---
Message posted from http://www.ExcelForum.com/

Thanks for the tip, I reversed the code and it worked. My bad!

Thanks again

--
Message posted from http://www.ExcelForum.com

Glad I could help.

Doug

"Excel-erate2004 " wrote in
message ...
Thanks for the tip, I reversed the code and it worked. My bad!

Thanks again!


---
Message posted from http://www.ExcelForum.com/

TRY ATTACHED YOU CAN GO EITHER WAY
JIM

Attachment filename: xlforum.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=55043
--
Message posted from http://www.ExcelForum.com