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
|