userform.show "in dimmed state"
Posted by Jim on December 30, 2001 4:04 PM
Jacob answered my question but i don't think i explained
myself clear enough so maybe this will help. On
commandbutton click i show a userform, before i use
the userform i need to enter a value in cell a10,so...
in order to enter the value in the cell i have to
mouse over and click on the cell to take the focus
away from the userform. That was why i was wondering
if on userform.show the userform could show "dimmed"
and i could immediately enter the value in the cell
without having to mouse over and click on the cell.