Ago
02-20-2008, 04:58 AM
when i run one of my macros there is a progressbar poping up in a userform.
the macro is changeing some values and such in the background (in my sheet) but because the stupid placement of the progressbar i cant see what its doing.
can i by code move the placement of the userform to the left or right so i can see whats happening?
second problem, is there a way to remove the "indicator" of a textbox?
the line that tells you where you are typeing.
the progressbar is made by two textboxes, one white and one blue.
the white one is "full width" and the blue one is growing while the macro is running.
that makes the illusion of a blue bar within a white area.
the problem is that this indicator is there and it looks awful.
the macro is changeing some values and such in the background (in my sheet) but because the stupid placement of the progressbar i cant see what its doing.
can i by code move the placement of the userform to the left or right so i can see whats happening?
second problem, is there a way to remove the "indicator" of a textbox?
the line that tells you where you are typeing.
the progressbar is made by two textboxes, one white and one blue.
the white one is "full width" and the blue one is growing while the macro is running.
that makes the illusion of a blue bar within a white area.
the problem is that this indicator is there and it looks awful.