imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
I'm trying to have my VBA code to show a msgbox with no buttons, but only with some information to the user.
The msgbox will stay on the screen until my VBA code sets Application.ScreenUpdating = True and Application.EnableEvents = True
I would like to have the vbInformation included in the msgbox, but NO BUTTONS.
Is this possible??
I have tried to have a userform popping up, giving me the same "please wait until data is imported and worksheet is properly formatted" info, but the VBA code won't preceed this userform. I have to manually clisk the [x] in the top right corner at the userform to get the code continue, and after about 15 seconds it dissapear and my worksheet is done.
Anyone ??
_________________
VikingS6
"I want to download Internet.
How large hard drive do I need??"
This message was edited by VikingS6 on 2002-10-06 13:00
The msgbox will stay on the screen until my VBA code sets Application.ScreenUpdating = True and Application.EnableEvents = True
I would like to have the vbInformation included in the msgbox, but NO BUTTONS.
Is this possible??
I have tried to have a userform popping up, giving me the same "please wait until data is imported and worksheet is properly formatted" info, but the VBA code won't preceed this userform. I have to manually clisk the [x] in the top right corner at the userform to get the code continue, and after about 15 seconds it dissapear and my worksheet is done.
Anyone ??
_________________
VikingS6
"I want to download Internet.
How large hard drive do I need??"
This message was edited by VikingS6 on 2002-10-06 13:00