listbox shrinks to a line when changing between sheets if I use the visible property

B

bikerchick

I created a listbox on a grid sheet. On the instruction sheet I chos
wether to use this listbox. I check to see if the user is using th
listbox and then I make it visible on the Grid sheet. When I go to th
Grid sheet it is a line and it gives me an error because I cannot rea
the value in the listbox because it is so small. I set the Height an
width dynamically and it still shows as a line when I go to the Gri
Sheet. I am using office 2003. Also if I turn the debugger off t
many times excel does not respond I have to go into task manager an
end task and start over. I also had instances when My code disappears.
Is any one having a problem with the vba 2003 environment
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top