rockwellsba
Technical User
Hello- I'm a novice. What I'd ULTIMATELY like to be able to do is have a user form create another user form based on information gathered by the first user form.
I pretty much know how to use VBA to create the second user form. What I'd like your help on is how I can use VBA to pull information from a document the user has created. Typical scenario: user types up a document with questions (Name:, Phone Number:, etc). Is there a way to use VBA to get the text (may be more than one word) that is located just before the colon? The document will have bookmarks inserted after the colon.
I would really appreciate some advice on at least getting started with pulling the text from the doc.
Thanks,
-Phil
I pretty much know how to use VBA to create the second user form. What I'd like your help on is how I can use VBA to pull information from a document the user has created. Typical scenario: user types up a document with questions (Name:, Phone Number:, etc). Is there a way to use VBA to get the text (may be more than one word) that is located just before the colon? The document will have bookmarks inserted after the colon.
I would really appreciate some advice on at least getting started with pulling the text from the doc.
Thanks,
-Phil
