Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2017, 03:12 PM
macropod's Avatar
macropod macropod is offline Userform textboxes Windows 7 64bit Userform textboxes Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,385
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


If you want multiple copies, simply add a field to your userform that allows the user to specify the number of copies, then have your code create as many as needed. Either way, there is no need to select (highlight) anything; it can all be done by referencing the table and/or cells concerned. Without seeing your document & userform, though, it's impossible to be more specific.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-03-2017, 12:55 AM
SonnyH666 SonnyH666 is offline Userform textboxes Windows 10 Userform textboxes Office 2016
Novice
Userform textboxes
 
Join Date: Oct 2017
Posts: 6
SonnyH666 is on a distinguished road
Default

Thats a great idea and i think that could work..

let me show you what i mean.



And either with highlighting or push of a button or something along the lines i want to be able to insert like this



So that i can push something in between the boxes.
What i do now is cut/paste from one text box to another

how would an example of a code look like with want you mentioned?
My text boxes are name Textbox 1-how many there are.
On screenshots the 2 texboxes on the left are name Textbox1 and Textbox2.
The boxes on the right stated with numbers are named Textbox3 (the big one) and textbox4 (the small one) and so forth.
So the code could be like cut/paste from textbox3 to textbox5 and textbox 4 to textbox6 or maybe it should be on focus so if i put my mouse on text box 7 it moves from there and downwards.....not sure how this can actually work out
Reply With Quote
  #3  
Old 10-03-2017, 01:26 AM
macropod's Avatar
macropod macropod is offline Userform textboxes Windows 7 64bit Userform textboxes Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,385
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As I said in my previous reply:
Quote:
Originally Posted by macropod View Post
Without seeing your document & userform, though, it's impossible to be more specific.
Screenshots aren't particularly helpful substitutes.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Userform Captions, TextBoxes, Command buttons From Excel dan88 Word VBA 3 05-22-2016 08:59 AM
Userform calls other userform, then populate worksheet Lehoi Excel Programming 0 02-03-2016 02:58 PM
VBA Code in a UserForm module to delete a Command Button which opens the userform Simoninparis Word VBA 2 09-21-2014 03:50 AM
UserForm Search with multiple TextBoxes johndough Excel Programming 0 05-10-2014 12:11 PM
Userform textboxes Many textboxes on top of each others? Giygas PowerPoint 1 12-05-2010 02:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:03 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