I have written a Macro that requires two comboboxes and a list box. After running the code and going to the sheet the boxes are located on, everything seems fine. The problem arises when I leave the sheet and go to another sheet then return to the sheet with the boxes. The start doing weird things. The text gets super tiny, or the boxes get huge. It seeems very capricious, as it seems to happen almost randomly. Here is the code I used for the combobox:
Here is the code for the listbox, which is very similar:
Has anyone else encountered this sort of thing? I have no idea what in the code is making those boxes do that. Any suggestions or idea would be greatly appreciated.
Bookmarks