Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Run a UserForm in the middle of a Macro

I'm having problems with coding how to run a UserForm while in the
middle of a Macro that already exists. The UserForm is called
"UserForm1". This seems like it would be simple but I am lost.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Run a UserForm in the middle of a Macro


"Astello" wrote in message
oups.com...
I'm having problems with coding how to run a UserForm while in the
middle of a Macro that already exists. The UserForm is called
"UserForm1". This seems like it would be simple but I am lost.

UserForm1.Show

--
Chris Lewis


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Run a UserForm in the middle of a Macro


"Astello" wrote in message
oups.com...
I'm having problems with coding how to run a UserForm while in the
middle of a Macro that already exists. The UserForm is called
"UserForm1". This seems like it would be simple but I am lost.

UserForm1.Show

--
Chris Lewis



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 272
Default Run a UserForm in the middle of a Macro

Sub YourMacro()
'code before userform
UserForm1.Show
'code after userform
end sub
--
Charles Chickering

"A good example is twice the value of good advice."


"Astello" wrote:

I'm having problems with coding how to run a UserForm while in the
middle of a Macro that already exists. The UserForm is called
"UserForm1". This seems like it would be simple but I am lost.


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Run a UserForm in the middle of a Macro

Thanks so much, Chris

Chris Lewis wrote:
"Astello" wrote in message
oups.com...
I'm having problems with coding how to run a UserForm while in the
middle of a Macro that already exists. The UserForm is called
"UserForm1". This seems like it would be simple but I am lost.

UserForm1.Show

--
Chris Lewis




  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Run a UserForm in the middle of a Macro

and Charles

Astello wrote:
Thanks so much, Chris

Chris Lewis wrote:
"Astello" wrote in message
oups.com...
I'm having problems with coding how to run a UserForm while in the
middle of a Macro that already exists. The UserForm is called
"UserForm1". This seems like it would be simple but I am lost.

UserForm1.Show

--
Chris Lewis


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Relative return to original worksheet in middle of macro [email protected] Excel Programming 2 June 2nd 06 06:52 PM
Remove middle initial from "first name middle initial" Justin F. Excel Discussion (Misc queries) 15 September 26th 05 06:13 PM
Stop running a macro in the middle of a macro gmunro Excel Programming 3 June 9th 05 06:00 PM
Macro dies in the middle of execution JonR Excel Programming 3 October 29th 04 06:20 PM
Select a cell in the middle of a macro execution Dave Bash Excel Programming 4 January 25th 04 11:48 PM


All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"