MrExcel Publishing
Your One Stop for Excel Tips & Solutions

userform.show "in dimmed state"


Posted by Jim on December 30, 2001 4:04 PM

Hi group,

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.

Thanks

Jim


Posted by Jacob on December 30, 2001 6:11 PM

Hi

Can you input the value into the userform and have vb put the value into the cell?

Jacob

Posted by Jim on December 30, 2001 6:22 PM

Hi Jacob,

The userform has 3 commandbuttons and 3 checkboxes
that (3,cb's - hide & show rows) & (3,chkbxs -
hide & show listboxes) so there is really no data
input involved.

regards,
Jim

Posted by Jacob on December 30, 2001 6:26 PM

Do you need to put values into the cell or just select it? Jacob,

Posted by Jim on December 31, 2001 8:10 AM

Hi Jacob,

I actually need to put a value in the cell

Jim

Posted by Jacob on December 31, 2001 8:54 PM

The easiest way to do it would be to add a textbox to the userform to put the data into and then have vb put the value in the cell. Or you can have an inputbox called at the point where you want to make the input and input the value there.

Jacob Jacob,