Thanks in advance

Excel Macros
Started by
The Josh
, Jun 19 2008 03:36 PM
#1
Posted 19 June 2008 - 03:36 PM

Thanks in advance
#2
Posted 22 June 2008 - 01:22 PM

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)
- VBA For Excel (You can go to the next page at the bottom, the link is kinda small)
- VBSript InputBox (To request information)
#3
Posted 27 June 2008 - 10:49 PM

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
Let me know if you need any more help.
Ax
#4
Posted 29 June 2008 - 07:42 PM

Cheers, you really helped a lot, however
You know where there's a list of the code-behind for me to use?
Thanks again
Josh
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
#5
Posted 29 June 2008 - 08:59 PM

#6
Posted 29 June 2008 - 09:01 PM

You're a star, cheers dude
#7
Posted 02 July 2008 - 10:48 PM


Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
As Featured On:






