![]() |
#2
|
|||
|
|||
![]()
You need to use the 'Visual' bit of VBA and design yourself a user form which collects all of the information you need.
There are lots of tutorials on the web so I'm not going to redo that here. Yours won;t be complicated as it looks like you only need two text fields to collect the information you need. A couple of comments on your code. 1. The select case for Ans does nothing because you have no code following the case statements. 2. Consider switching from a document variable to a custom document property. The advantage of a custom document property is you can edit the value from the properties dialog box which is accessed via the Backstage page. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with Case and Select case | brent chadwick | Word VBA | 34 | 10-18-2015 02:13 PM |
Replace & case | Jennifer Murphy | Word | 1 | 02-11-2013 03:26 AM |
![]() |
kyjac85 | Word VBA | 13 | 09-20-2012 05:00 PM |
Problem with the sendkeys in Win7 | vidyapakki | Excel Programming | 1 | 05-07-2012 11:10 PM |
![]() |
davers | Word | 1 | 04-30-2009 12:41 PM |