ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cursor mystery... (https://www.excelbanter.com/excel-programming/356132-cursor-mystery.html)

Jay

Cursor mystery...
 
The following VBA statement fires up a form with a blinking cursor in
EditBoxes(1) as desired:
DialogSheets("ControlForm").Show
A separate routine clears lthe contents from all edit boxes on the form, but
the cursor disappears (doesn't show in any editbox) and I can't seem to get
it back unless the Form is closed and opened again.

The following statements have been tried, but neither works:
DialogSheets("ControlForm").EditBoxes(1).SetFocus
DialogSheets("ControlForm").EditBoxes(1).SetFocus = True

Also, if there is an entry in the "home" field (the field where the cursor
should appear when the rest of the form is cleared), it would be nice if the
entire box was highlighted so the user could replace the contents just by
typing.
--
Thanks a bunch in advance,
Jay


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com