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?

How do I adjust a combobox once I've Programmed it?
 

Switch the workbook to Design Mode you can then select and edit the
controls.

--

Regards,
Nigel




"Plateriot" wrote in message
...
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?

How do I adjust a combobox once I've Programmed it?
 

Although you said you had a "Forms combobox", you don't sound like you are
describing a ComboBox from the Forms toolbar; rather, you sound like you are
describing a ComboBox from the Control ToolBox toolbar. Although this can be
viewed by itself, it needs the Visual Basic toolbar in order to flip between
Design Mode on and Design Mode off. If you turn Design Mode on on the Visual
Basic toolbar, you should be able to edit the properties for the ComboBox.
Well, of course, you deleted it, so this is all academic now I guess.<g

Rick


"Plateriot" wrote in message
...
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?