Combobox to set value in cell on worksheet
 

I have a combobox on a worksheet named "PORev1" and in the properties I have
the ListFillRange set to retrieve the following Sheet1!$C$2:$D$12. The
question I have is that after I select appropriate value I would like it to
place it also in the PORev1 worksheet in cell J13. I am unsure on how to do
this, I am familiar with access and vba, however this is my first dabble into
excel and vba to control it. Plus the help files IMHO are lack luster. Any
help would be greatly appreciated.

Thanks much in advanced

Combobox to set value in cell on worksheet
 

Assuming you have a combobox from the Control Toolbox and not from
the Forms toolbar, then in the properties window for the combobox
enter "j13" as the LinkedCell.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"default105"
wrote in message...
I have a combobox on a worksheet named "PORev1" and in the properties I have
the ListFillRange set to retrieve the following Sheet1!$C$2:$D$12. The
question I have is that after I select appropriate value I would like it to
place it also in the PORev1 worksheet in cell J13. I am unsure on how to do
this, I am familiar with access and vba, however this is my first dabble into
excel and vba to control it. Plus the help files IMHO are lack luster. Any
help would be greatly appreciated.

Thanks much in advanced