Home Case Studies MS Office Tips and Tricks Sample Code Helpful Videos Custom Development  Custom Training Join Us Contact Us
Search Our Site:  

Capturing the contents of text boxes and list boxes

You probably know that you can use the PrintScreen button on the keyboard to copy everything on your screen to the clipboard, or ALT-PrintScreen to copy the active window. From there you can paste the snapshot into any Windows application like Word or Outlook. These pictures are typically referred to as screenshots. PrintScreen is pretty limited, but at $0 US (0.00 €), you can hardly argue with the price.

Snagit from TechSmith (http://www.techsmith.com) allows for much more functionality than simple screen capture. In fact, if you code in VBA, you can programmatically capture images. See our TechSmith interview concerning database documentation and the sample code we used.

In addition to a variety of image capture options and image editing, the program allows for text capture. Using optical character recognition, Snagit can ‘read’ the text off the computer screen and represent it not as a picture, but as actual text.



Our favorite is text capture from a scrolling window. Take for example the Tools > References… list in the VB Editor. It can have hundreds of entries and finding the library to reference is difficult.



Since you can’t search a list box or text box, you have to look at each entry individually. With the Auto Scroll Window feature and text capture, you can click on a long combination box, drop down list or list box and pull everything out in text. Then just do a simple copy and paste into Word or Excel and use their text searching functionality to wade through all of the choices. 

See the video in Windows Media format and try it on your own drop downs and list boxes.

 
Please share your comments on this article!

 
Name (opt)
Email Address (opt)
Your Questions/
Comments

I Get It! Development does not share your email address or other information, nor do we add you to any mailing lists unless you specifically request to be added by checking the box below.



SEE ALSO
You may also find the following articles useful:


Custom Buttons

Replace MEGAFORMULAS With VBA

Multiple Ways To Get To Your Data

Chart Automation Success Story

Billing Made Easier With Access

Custom Training Success Story

Calculate Growth Rates In Excel

Spreadsheet vs. Database

Pimp My Spreadsheet!

Columns In Word

Bound vs Unbound Forms

Subqueries In Access

Amazing Excel Comments

Deduplicate Excel Data

References

Journal of Accountancy Articles

Tweaking The Numbers

Block That Spreadsheet Error

Excel Security Issues


 

Clients

Do you need help with Microsoft Office? Contact us

See how we've helped companies like yours develop effective business processes

Client Success Stories


 

Consultants

I Get It! Consultants set their own hours, work with their own clients, and choose their own projects.

If you're a Microsoft Office guru and would like to explore being a full-time consultant, please see our consultant information pages.