Thread: [Solved] Userform textboxes
View Single Post
 
Old 10-02-2017, 01:48 PM
SonnyH666 SonnyH666 is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2017
Posts: 6
SonnyH666 is on a distinguished road
Default Userform textboxes

Hi everyone

I have been looking for a solution for my problem for the last 6 hours by googling and what not and still i cant find any solution so im trying my luck here.

Ive made an template to fill out dividers for physical folders, where press a button and user form pops up where i can fill out my data, which then is being inserted in tables with bookmarks, so far so good, now one of my colleagues (this is Work related) wanted to be able to highlight the text in the textboxes and then copy paste it into another textbox and fill out the values past the one you past into first....(kinda hard to explain as English isnt my native language so bare with me). Like in tables when you want to move everything one place Down you hightlight everything place the cursor in the table you wanna start in and the paste and the rest of the tables gets filled out. But i cant seem to find any options to hightlight text in multiple textboxes sooo I was considering a button called move up and a button called move Down and when you press the move Down all text gets moved to the textbox below and the rest of the text in the other boxes gets filled out after that.

IVe tried this code but cant get it to Work
https://www.mrexcel.com/forum/excel-...m-up-down.html
ive then tried something along the line with replace text from textboxX to textboxY but it doesnt quiet Work as i want it to, so i was hoping anyone in here could point me in the right direction. FYI im totally new to VBA, and everything ive made has been codes ive found around the web and somehow put it together to make it Work (pure luck if you ask me).
If description is confusing i can make som screenshots of what i want or even upload my template if needed, thanks in advance
Reply With Quote