Display UserForm on TaskBar?

[tab245]

Hi!

Is there any way to display Excel VBA UserForm on the TaskBar?


Thank you!
Tab

 

[RobBroekhuis]

No, not per se, but describe what you're trying to accomplish and maybe we'll come up with a workaround.
Rob

 

[tab245]

Hi, Rob,

I am calling Excel macro from VB program. Excel is minimized all the time (by some reason it is even not displayed on the task bar...). So, I have the VB window, and above it I have a UserForm generated by Excel. However, if I switch to any other application (e.g., internet), I can not get the UserForm displayed again. The VB window is displayed, but there is not Excel UserForm above it! So, I can not see what the Excel macro is doing and if it works at all. If I click on VB window, I get the message “The action can not be completed because the other application is busy”. When I choose “Switch to…”, nothing happens…

Tab

 

[RobBroekhuis]

I know this is not the solution you're hoping for, but... Wouldn't it be cleaner to execute the code you need all from within VB, instead of calling on an Excel macro? You retain much more control that way, and you can do everything from within VB that you can do in Excel VBA.
Rob

 

[tab245]

Yes, this would be good...
Unfortunately, I am using Excel Solver in my optimization problem. It is free as opposed to VB Solvers, that cost a lot...

Thank you anyway!

 

[RobBroekhuis]

I still don't see why you can't use Excel solver without using Excel macros. Are the userforms you are talking about generated by your Excel code, or do you mean the forms that the solver puts up?
Rob

 

[tab245]

hm... the UserForms are coming from VBA code that I created...

VB program calls "main" macro in Excel. This macro, in turn, calls several other subrutines and displays three UserForms, which shows what task is performed ("constracting graph..", etc).

Yes, maybe, instead of calling one "main" macro from VB and then managing process within Excel, I can operate it by VB program... I will try this. Thanks!