Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I do this with a TextBox?
User opens a book, containing a single sheet. Code in the
Workbook_Open Event runs and if certain conditions are met then a TextBox created by the Drawing toolbar is displayed and enabled for data entry. User enters their data, and when they click a cell outside the textbox (ie exit the textbox) CheckSpelling will automatically run on just the textbox. Having done so, user would be free to re-enter the textbox, but again, CheckSpelling would run when they exit. An ActiveX textbox is fine, except that it doesn't offer the bells and whistles features of Spell Checking. Hope this makes sense. Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.727 / Virus Database: 482 - Release Date: 26/07/2004 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Textbox value based on another textbox value.doc | Excel Discussion (Misc queries) | |||
Calculate Textbox value based on another textbox value | Excel Discussion (Misc queries) | |||
getting textbox value | Excel Programming | |||
to textbox | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |