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

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" wrote:

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

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

Craig

"OssieMac" wrote in message
...
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" wrote:

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