Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return focus to Excel App

Status
Not open for further replies.
nickjar2

nickjar2

Programmer
Jun 20, 2001
778
US
I have some code in Excel:

Else
Unload frmLogin
MsgBox "Cannot carry out import. Unable to log in to Business Objects!", vbCritical
Exit Sub

The frmLogin unloads, but Excel then flashes and I have to either click on Excel in the task bar or click on the excel title bar to show the msgbox. Is there some code that, after unloading the user form, i can use to return focus to the excel spreadsheet so the user is shown the msgbox. Otheriwse, they will have to click on excel to see it.

Does this make sense?

Cheers,

Nick
 
Status
Not open for further replies.

Similar threads

shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
900
shytott
shytott
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
306
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
301
combo
combo
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
696
SoftwareRT
SoftwareRT
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
311
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top