How To Create Popup Window Within Excel to Show On First Use?

[aedctalk]

Hi. I just did a search for popup window that didnt turn up anything.. Can't be the first to ask this question though. :/

I was hoping there is some kind of code to where If Configuration!J12 = "" (empty) that then i could have a popup window open on workbook load within excel that contains some text and a couple buttons. (that directs them to fill out some information)

Is I know there is a way to load things on workbook open but how exactly do i make a popup window.. Say Size 400w x 200l? show up in the center of the excel worksheet with?

I'm guessing easiest way is to create a worksheet with the text and buttons i want then open that worksheet on workbook load and somehow resize it?

not looking for an alertbox..

I dunno. really lost. Some helpful code or links would be awesome :P

 

[AlphaFrog]

Do a web search of Excel UserForm tutorial or something like that. What you are calling a custom pop-up window is called a UserForm in Excel VBA.