View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Plateriot Plateriot is offline
external usenet poster
 
Posts: 3
Default How do I adjust a combobox once I've Programmed it?

This really boggled me.

I programatically added items to a Forms combobox that I added to a worksheet.

But then I realized that I hadn't formatted it properly, the box was too
small, and the Font was too large...

I couldn't right click it to get the properties, I couldn't even delete it.

I finally found some code to delete a combobox object and that's how I got
rid of it!

It's probably something simple that I missed, but how do you get back to the
'virgin' state of a combobox when it is first placed on the worksheet so that
I can edit the properties, if I'm not satisfied with the way it looks at
runtime?