Pass multiple values unto the same column

SoraSenoie

New Member
Joined
Mar 24, 2021
Messages
8
Office Version
  1. 365
Platform
  1. Windows
I have an userform that users toggle buttons to that will make text boxes appear if toggled but I have issues passing the date if two toggle boxes are pressed
for example

toggle box1 = true then 2 text boxes will appear where users will put data in
toggle box2= true then 2 text boxes will appear where users will put data in

togglebox.caption will go on column D and the text boxes will go on column E

so far i have gotten both of them to pass through but if one is not pressed the other one wont pass through or sometimes it will only pass one but not the other
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,214,832
Messages
6,121,844
Members
449,051
Latest member
excelquestion515

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top