View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Form Controls on Worksheet

Can you expand your description for us? Are you asking about doing this in
VB code? When you say "array", do you mean a range of cells or an actual VB
array? If the latter, what data type (Variant, String, etc.) is the array
declared as? And I'm assuming from your brief description that your ComboBox
is on a worksheet and not a UserForm, right?

--
Rick (MVP - Excel)


"H.G. Lamy" wrote in message
...
Hello,

can I use an array as input range for a combo box (I mean form controls,
not ActiveX controls) ?

Kind regards,

H.G. Lamy