Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-23-2018, 02:59 AM
slaycock slaycock is offline SENDKEYS with vbYesNoCancel and Select Case Windows 7 64bit SENDKEYS with vbYesNoCancel and Select Case Office 2016
Expert
 
Join Date: Sep 2013
Posts: 255
slaycock is on a distinguished road
Default

You might know more than you think. If you have enough knowledge to get as far as opening the VBA IDE and tinkering with code then you have enough knowledge to have a go at at least trying to create a form.

Lets assume that you want a simple form that has two input boxes and two buttons (OK and Cancel).

In the VBA IDE use

Insert.UserForm

This will open up a page that displays an empty userform.

You will also see in the 'Properties' window a set of properties available to the form.

Change the Name to 'ufrmPrintNumberedCopies'
Change the Caption to 'Print Numbered Copies'

When you change the caption text what you entered should appear in the blue bar at the top of the user form.

See if you can get this far. If you can then with a small amount of guidance it should be perfectly possible for you to revise your code to use a user dialog box.

If you don't see a properties windows (usually in the bottom left corner of the screen) then you will need to enable its display.

inthe VBA IDE

View.Properties Window
Reply With Quote
 



Similar Threads
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
SENDKEYS with vbYesNoCancel and Select Case A macro that can insert FILENAME, sendkeys CTRL ALT T, paste clipboard, and nextline 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
SENDKEYS with vbYesNoCancel and Select Case From all UPPER CASE to Proper Case davers Word 1 04-30-2009 12:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft