ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run a UserForm in the middle of a Macro (https://www.excelbanter.com/excel-programming/375201-run-userform-middle-macro.html)

Astello[_2_]

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.


Chris Lewis[_2_]

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



Chris Lewis[_2_]

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




Charles Chickering

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.



Astello[_2_]

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



Astello[_2_]

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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com