ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SetFocus does not show cursor in initialize (Excel VBA) (https://www.excelbanter.com/excel-programming/321460-setfocus-does-not-show-cursor-initialize-excel-vba.html)

Tamara Plute

SetFocus does not show cursor in initialize (Excel VBA)
 
The focus is where I want it to be, but the cursor does not appear when
the form initializes. When initially opening the excel file I have the
spreadsheet minimize and form initialize. Once the doc is open I also
have a macro to show the form if it has been closed. The cursor is
visible then. Any ideas?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Tom Ogilvy

SetFocus does not show cursor in initialize (Excel VBA)
 
If this is done on initialize, why not use the taborder property.

--
Regards,
Tom Ogilvy

"Tamara Plute" wrote in message
...
The focus is where I want it to be, but the cursor does not appear when
the form initializes. When initially opening the excel file I have the
spreadsheet minimize and form initialize. Once the doc is open I also
have a macro to show the form if it has been closed. The cursor is
visible then. Any ideas?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!




Plutopotamus

SetFocus does not show cursor in initialize (Excel VBA)
 

Thank you, Tom! I had the tab order set to start there so I guess the
setfocus was not necessary. Thanks for another solution!


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


All times are GMT +1. The time now is 05:32 PM.

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