Combobox to set value in cell on worksheet

D

default105

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
 
J

Jim Cone

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" <[email protected]>
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
 
Top