Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep comboboxes stationary
I have an application I'm building where I open (unhide) and close (hide)
sections of one worksheet to make it appear somewhat like opening and closing a folder. I'm using a few comboboxes to provide a more visible list of options for each as I'v set the zoom to 66% because of all of the data and charts. I've had to go with comboboxes because the data validation feature provides no way for me to control the font size, which in this case at 66% is way too small to read. My problem is that when I first draw the comboboxes the are in the right place. However, when I close Excel and reopen the workbook the comboboxes have been placed much lower on the worksheet 'automagically' by Excel without me telling Excel where to put them. So, my question is, "is there a feature or method to keep each combobox locked in position over the cell that it represents?" Currently, I have even tried telling Excel exactly where to put them but that doesn't work either (example below). With Sheetname.ComboBoxName_cb .Left = 747 .Width = 144.75 .Top = 124.5 .Height = 19.5 .AddItem "Selection 1" .AddItem "Selection 2" .AddItem "Selection 3" .AddItem "Selection 4" End With Has any one else run into this? Sincerely, Bryan44 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
top row stationary | Excel Discussion (Misc queries) | |||
Stationary Row | Excel Discussion (Misc queries) | |||
Stationary Header | Excel Discussion (Misc queries) | |||
Making a column stationary | Setting up and Configuration of Excel | |||
Stationary Column | Excel Discussion (Misc queries) |