Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2020, 05:46 PM
glowe glowe is offline Numberings or headers Windows 8 Numberings or headers Office 2010
Novice
Numberings or headers
 
Join Date: Jul 2020
Posts: 1
glowe is on a distinguished road
Default Numberings or headers

So I want to create a vba program that when I type in the number "35" into my userform, it creates the following:

RESPONSE TO NUMBER 1

RESPONSE TO NUMBER 2
So on and so forth, to whatever # i insert. What's the best approach to this?



Is there a sample code someone has?
Reply With Quote
  #2  
Old 07-23-2020, 08:18 PM
Charles Kenyon Charles Kenyon is offline Numberings or headers Windows 10 Numberings or headers Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I do not know that vba is needed. Try a SEQ field and AutoText. (AutoText can be tied to a keyboard shortcut).
See: SEQuence Field for examples with Interrogatories
Reply With Quote
  #3  
Old 07-23-2020, 08:22 PM
Charles Kenyon Charles Kenyon is offline Numberings or headers Windows 10 Numberings or headers Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by glowe View Post
So I want to create a vba program that when I type in the number "35" into my userform, it creates the following:

RESPONSE TO NUMBER 1

RESPONSE TO NUMBER 2
So on and so forth, to whatever # i insert. What's the best approach to this?

Is there a sample code someone has?

In your userform? Where are you going to type it? A userform is a custom dialog box not a form for a user.
Create a Simple Userform by Graham Mayor, MVP
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Headers Bionic Word 4 03-13-2017 07:10 AM
Word 2010: Table of Contents and Numberings ProfGiova Word 4 10-08-2014 04:44 PM
Help with headers Richtriebe Word 3 04-20-2013 10:33 AM
Numberings or headers Using Headers Bunden Word 1 08-02-2012 11:18 AM
Numberings or headers Question about headings and numberings cgat Word 1 06-05-2011 07:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:01 AM.


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