How to wrie a macro to create a dialogue box with a command button?

[roopa m j]

Hello all,

i have written a macro to calculate certain values and it is successful.

now, i need to display a dialogue box when an excel sheet is opened, having a welcome text as " A Tool for data post processing" and a command button as "Run the macro".

when this command button is clicked, the macro which i have created should run.

i am new to writing a macro for buttons or dialogue boxes and have no idea on how to do it.

any suggestions is welcome .
awaiting your response.

thank you
Roopa

[vaibhav2312]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[akhileshgs]

For displaying message, you can try this

And for getting a button, just go to developer option>>Insert>> First button(or Box) draw that as per your need>>right click on the box>> assign macro>> Done

[:) Sixthsense :)]

Try liket this by adding the below code in Thisworkbook Code window

Please Login or Register  to view this content.

[roopa m j]

Thanks all.

i tried these codes. it works without any codes but the userform is not displayed.

but i have a very basic doubt. kindly excuse my dumbness..

should i give these codes in a seperate module of code or should i write this where the userform is created.

Thanks
Roopa

[roopa m j]

Please Login or Register  to view this content.

This is the code i get when i go to "view code" of the userform which i have created.

so should i enter the codes which u all gave into this code or seperately?

Roopa

[roopa m j]

all of these codes are working.

but how do i get the userform displayed?

it is directly running my macro.