ExcelBanter - Userform

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Userform (https://www.excelbanter.com/excel-programming/303719-userform.html)

Todd huttenstine

Userform

Hey guys

How do I make a userform come up and still be able to do
things in Excel like change cell values and so on without
having to close the userform first?

Todd

Chip Pearson

Userform

You can do this in Excel 2000 and later.

UserForm1.Show vbModeless

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Todd Huttenstine" wrote in
message ...
Hey guys

How do I make a userform come up and still be able to do
things in Excel like change cell values and so on without
having to close the userform first?

Todd

Todd huttenstine

Userform

Thanks. Is there anyway to make it go behind other
windows?

-----Original Message-----
You can do this in Excel 2000 and later.

UserForm1.Show vbModeless

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Todd Huttenstine"
wrote in
message ...
Hey guys

How do I make a userform come up and still be able to do
things in Excel like change cell values and so on
without
having to close the userform first?

Todd

.

Todd huttenstine

Userform

Also why does this not talk about vbModeless in the help
file?

-----Original Message-----
You can do this in Excel 2000 and later.

UserForm1.Show vbModeless

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Todd Huttenstine"
wrote in
message ...
Hey guys

How do I make a userform come up and still be able to do
things in Excel like change cell values and so on
without
having to close the userform first?

Todd

.

All times are GMT +1. The time now is 02:46 PM.