[The Josh]

Only recently started working with macros, can do all the basic usual stuff like inserting data, changing data etc, but is there a way to design a macro, where when i click it a box pops up asking questions about what data to input? For example, I click the button, a window pops up, it asks what time i started a job, what time i finished, when i had breaks and what rate i was getting paid for it, then calculates how much i get paid and displays it in a cell?
Thanks in advance

[Advertisements]

This should be possible by using Visual Basic for Excel, here are some links that will help you:

- VBA For Excel (You can go to the next page at the bottom, the link is kinda small)
- VBSript InputBox (To request information)

[TomWij]

This should be possible by using Visual Basic for Excel, here are some links that will help you:

- VBA For Excel (You can go to the next page at the bottom, the link is kinda small)
- VBSript InputBox (To request information)

[Ax238]

You can use an InputBox to ask specific information, just search help in VBA for the syntax. With this approach though, you'd have to have an input box for every piece of information you want to put in the cells, unless you concatenate all the values together. The only other method is to create a UserForm. In the Visual Basic Editor window (Alt-F11 when you open Excel), choose Insert | UserForm. After that, it's just a matter of putting the input controls, labels, and buttons on the form and adding the code-behind.

Let me know if you need any more help.

Ax

[The Josh]

Cheers, you really helped a lot, however

After that, it's just a matter of putting the input controls, labels, and buttons on the form and adding the code-behind.

You know where there's a list of the code-behind for me to use?

Thanks again
Josh

[Ax238]

Josh,

The following link may give you a good start:
http://www.contextur...UserForm01.html

Regards,

Ax

[The Josh]

You're a star, cheers dude

[Ax238]

No problem at all.