Allow user to block-enter data in userform textboxes

j844929

Active Member
Joined
Aug 18, 2002
Messages
423
Hi,

I just wondered if there's a setting or something that can run when a userform is activated, which allows the user to select more than one textbox at a time and enter identical data into the selected boxes.

The userform I have splits the day into 48 hourly periods. I want to be able to enter the same number into all of them at the same time, if required, or blocks of a few at a time...

Any ideas?
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
I don't think so (could be wrong). But you could just add a control to the user form to do it for you. Possibly a checkbox that when selected would make all textboxes equal to he value of textbox1.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,229
Messages
5,571,019
Members
412,354
Latest member
Stj99
Top