Help Files in Excel using VBA

[hoops12]

Hi. I need to have help files pop up when a user clicks a button. problem is i need them to be able to just follow it step by step so they need to work in workbook at same time. anyone have suggestions as to how to go about this?

 

[RobBroekhuis]

I've done something like that before using a modeless userform (need to be XL2000 or better to use those). That kind of userform will stay onscreen while the user is free to do other things in Excel. You show it using

userform1.show vbModeless

If that sounds like a solution and you need more help, let us know.
Rob

 

[hoops12]

Hi! Thanks for the info. Unfortunately it is not xl2000 or better...
Another idea would be to have the instructions pop into some sort of control onscreen but i'm really not sure how to approach this. Seems like something that shoudlnt' be so complicated!

 

[RobBroekhuis]

Yes, you can use on-sheet controls. A textbox would work just fine. Record yourself creating one and putting some text in, and then copy, paste, and manipulate the code until it does what you need it to do on demand. Rob

 

[hoops12]

ok..good idea..thanks so much for your suggestions!