Help with Spreadsheet Toolbox Control

[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

 

[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.

 

[Craig M]

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

Craig