VBA

J

John

I have a little problem. I need to write a VBA. I have a button that will
print four letters that are located in a seperate worksheet. Currently I
have a macro that goes to that worksheet and prints all four. But I want to
have a pop-up that will ask Which letter they want to print. I believe that
this is possible, but i need some help developing it. Any help would be
appreciated.

Thank you
 
A

Arvin Meyer [MVP]

John said:
I have a little problem. I need to write a VBA. I have a button that will
print four letters that are located in a seperate worksheet. Currently I
have a macro that goes to that worksheet and prints all four. But I want to
have a pop-up that will ask Which letter they want to print. I believe that
this is possible, but i need some help developing it. Any help would be
appreciated.
Click to expand...

Is this an Access question? I ask because there are no "worksheets" in
Access. Perhaps you mean datasheet? But from where? Table? Query? Form? VBA
is similar for every application, but there are slight differences. Why
don't you give us some of the particulars? Application, version, names of
objects, etc.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top