Help with Spreadsheet Toolbox Control

C

Craig M

Hi, I'm using a spreadsheet control in my userform. I have a little problem
that I can't figure out. I am trying to select the first blank cell in
spreadsheet1 column "D". I do know how to do this... my problem is that when
the code selects the first blank cell in "D" I wish to be able to type and
the data is entered into the blank cell imediately. I find that I have to
manually click on the blank cell before it will let me type into it, is
there a way around this?

Thanks
Craig
 
O

OssieMac

Are you using an Active X control? If so, try setting the control property
"TakeFocusOnClick" to False because if it is set to True then the Control has
the focus and you need to click on the cell for it to take the focus.
 
C

Craig M

The SpreadSheet1 Control doesn't have "TakeFocusOnClick" like the buttons
and other controls.

Craig
 

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