View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
Dom_Ciccone Dom_Ciccone is offline
external usenet poster
 
Posts: 52
Default another combobox question

Use the ControlSource property. If linking to cell C3 on a worksheet called
"DataSheet" just simply set the ControlSource property to:

DataSheet!C3

Note the exclamation mark

"teepee" wrote:

Anyone know how to set the link cell on a combobox inside a userform? I was
expecting to see something in vba properties like 'linkedcell' (like you get
in the control toolbox combobox) but it's not there.

Many thanks

tp