Command Button VBA Code

[kiddos5]

I have an assignment to code a command button then assign a VBA macro to it. When the command button is initiated it should give a list of titles (Headers) to sort the data by. My headers are Day, Called, Nature of Call, & Length of Call. I know how to record a macro and how to insert command button, but am clueless how to do this. Can anyone help? Thanks in advance.

[stnkynts]

Dear kiddos5,

I am a little hesitant to give you a direct answer because to me this sounds like a homework assignment. Maybe others on the forum might be more inclined to just give you the answer and send you on your way but I think your teacher might notice the difference between the advanced code some can give and the beginning code you can generate yourself.

Some tips:
- you know how to record a macro and you know how to insert a command button. Just copy the recorded macro into the code source of the command button and it should word on-click.
- not sure what you mean by "give a list of titles" but if it is simply a list then a simple message box would work. The message box can include your text plus cell values (titles in this scenario).

If you have specific questions on your code feel free to ask. If I am wrong on this being a homework assignment and in actuality is a work related project let us know and we can talk about the specific information we will need to help you out.

[jeffreybrown]

Along with what stnkynts said, what about...

http://office.microsoft.com/en-us/ex...010236676.aspx

...and google can pull up lots of helpful hints and advice.