TextBox - CheckSpelling question
 

I would like to position a text box 'over' the range "B2:L50".
"B2:L50" would be locked and the textbox disabled when
the workbook is opened, only becoming Visible / Enabled
when a condition is met.
When met, user can type in the textbox, where the text will
wrap, and both the Enter and Tab keys will work normally.

This I can achieve, using a TextBox from the Controls
ToolBar.

What I am not permitted to do, is to then use 'CheckSpelling'
on the user's data.

I've been working with Excel2k, but could use Office 2003
SBE.

How can I change my approach, such that 'CheckSpelling'
will operate on the textBox, please?

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004

TextBox - CheckSpelling question
 

Hi Stuart,

See this post from Jake Marx:

http://tinyurl.com/46bn4


---
Regards,
Norman




"Stuart" wrote in message
...
I would like to position a text box 'over' the range "B2:L50".
"B2:L50" would be locked and the textbox disabled when
the workbook is opened, only becoming Visible / Enabled
when a condition is met.
When met, user can type in the textbox, where the text will
wrap, and both the Enter and Tab keys will work normally.

This I can achieve, using a TextBox from the Controls
ToolBar.

What I am not permitted to do, is to then use 'CheckSpelling'
on the user's data.

I've been working with Excel2k, but could use Office 2003
SBE.

How can I change my approach, such that 'CheckSpelling'
will operate on the textBox, please?

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004

TextBox - CheckSpelling question
 

Many thanks.
Had seen this when checking Google before posting.
Assumed this method meant that the in-built prompt
(ie alternative suggestions for a mis-spelt word) would
not display.
Have to say, I did not check that.

Regards.

"Norman Jones" wrote in message
...
Hi Stuart,

See this post from Jake Marx:

http://tinyurl.com/46bn4


---
Regards,
Norman




"Stuart" wrote in message
...
I would like to position a text box 'over' the range "B2:L50".
"B2:L50" would be locked and the textbox disabled when
the workbook is opened, only becoming Visible / Enabled
when a condition is met.
When met, user can type in the textbox, where the text will
wrap, and both the Enter and Tab keys will work normally.

This I can achieve, using a TextBox from the Controls
ToolBar.

What I am not permitted to do, is to then use 'CheckSpelling'
on the user's data.

I've been working with Excel2k, but could use Office 2003
SBE.

How can I change my approach, such that 'CheckSpelling'
will operate on the textBox, please?

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004