UserForm with Multiple Option Buttons in Excel and VBA

Рет қаралды 102,673

Күн бұрын

This tutorial will demonstrate how to use Multiple Option Buttons in User-form in Excel and VBA. You will learn to create multiple Option Button Groups in a Data Entry Form and use the same in transferring the data from VBA Form to Excel Table or Sheet.
#MultipleOptionButtons #TheDataLabs
Please follow the below link to download the Excel file used in this video.
thedatalabs.org/userform-and-...
Please visit our website www.thedatalabs.org
Please contact us on thedatalabs@gmail.com
Thanks for watching!
Please like, share, comment and subscribe.
Have a great day!

Пікірлер: 49

@marinaalcantara275 3 жыл бұрын

Thank you! Great explanation! Just what I was looking for!

@markanthonyartiaga5325 2 жыл бұрын

You're a life-saver... Thank you!!!

@tonywatson8101 2 жыл бұрын

Thanks for posting this tutorial. Solved my problem !

@belalyahya6338 4 жыл бұрын

You helped me a lot , i owe a favor you are amazing , keep the good work Really appreciate it , god bless you .

@bas3995 4 жыл бұрын

Sir, it is really nice to watch your videos and Learn more

@querrythis 2 жыл бұрын

You answered my dilemma. Thank you very much

@ashleynewberry698 3 жыл бұрын

Finally someone explained and demonstrated how to do this! I appreciate your help. Great video.

@user-tl9kn3se8j 4 жыл бұрын

Thanks you!

@cristineiran7273 3 жыл бұрын

Thank you for sharing... Very helpful...

@abdallahsalheen6795 3 жыл бұрын

Awesomely awesome, thank you so much . subscribed and wait for more

@BestFriendsForeverTrue 4 жыл бұрын

Thank for your free application form

@Caio_Freitas 2 жыл бұрын

Good explanation! Great video!

@Choman878 10 ай бұрын

Thanks solved my problem ❤

@AjaySingh-ll5qw 4 жыл бұрын

Really useful

@tawfeeqallah9609 3 жыл бұрын

Thank you very much You have learned how to group option buttons

@thedatalabs 3 жыл бұрын

Thanks!

@isaackudjo2799 3 жыл бұрын

you will leave long. God bless u

@NR-mh9zj 4 жыл бұрын

Everyday im waiting for your vedeo. The reason is your fantastic explanation 👌

@thedatalabs 4 жыл бұрын

Thanks for your kind words! I will try my best to meet your expectations in upcoming tutorials as well.

@NR-mh9zj 4 жыл бұрын

@@thedatalabs Thanks for your reply.

@abdullahalshehri2218 3 жыл бұрын

@@thedatalabs need to contact you for business work

@vijaysahal4556 3 жыл бұрын

nice 👍🏻👍🏻👍🏻👍🏻

@lazimhabtamu8933 4 жыл бұрын

Thanks Sir!! How can we insert multiple Lable in One group, For Example, If you have work experience level within the user form how to set different organization experience with position+service year on text box. In addition to this, please show monitoring follow up format by adding daily performance to calculate monthly and to date progress including how to edit.

@southparklion Жыл бұрын

This is great. How can I make a similar data entry form that allows me to label column headers so that I can append query to add that data to an existing table?

@joshblock3905 Жыл бұрын

Can you point me toward a training to use radio buttons or a selection list to choose which paragraphs should be included in a document. For example, I am creating a statement of work, and on the userform, I select the options I'll include in the SOW. If an option is selected, a paragraph is included in the SOW. If it's not selected, a shorter paragraph is included in the exclusions section of the SOW.

@yuosefhbbc622 3 жыл бұрын

Very nice explanation, But how you can stop the process when no selection of option buttons.

@aqireenzaqilah 2 жыл бұрын

How about multiple info in combo box like customer order 5 items?

@danny-lv4rw 4 жыл бұрын

How to check birthday reminder in Excel userform please tell me sir

@silviachis1 3 жыл бұрын

Hi. Can you have multiple answers in one group? Thank you!

@thedatalabs 3 жыл бұрын

For that, you can use Check box control. Thanks!

@jahidabdulbayan2432 3 жыл бұрын

Please teach me how to have the correct codes in creating a employee data entry form database

@thedatalabs 3 жыл бұрын

Are you getting any error? Please share the line of code. Thanks!

@bhaskarpawar8613 3 жыл бұрын

how to create dependent option box to option box , and option ox to combo box in vba excel plz

@vistazoproductions 4 жыл бұрын

How come I cant do this kind of forms on Mac ?

@thedatalabs 4 жыл бұрын

Please download the file from the link provided in description box and then try to open it on your system. Mac system has some different UI.

@NikitaDugin 2 жыл бұрын

Error 1004 withing this row: {iRow = Sheet1.Range("A" & Rows.Count).End(x1Up).Row + 1}. Update: Solved! {x1Up} - I had a digit {1} whereas it should be a lower case L {l}. P.S. Thanks to SJR from Stackoverflow.

@vasanthikrishnan6393 2 жыл бұрын

Hi sir i want to create customer survey in excel.

@juadadeeb7663 3 жыл бұрын

thnks alot but msg showed to me (error) object recuired 424 first line after dim i row as long

@manuelakiteculo7435 3 жыл бұрын

Were you by any chance able to solve this?I'm getting the exact same things

@gurusiddayyaswamikulkarni6392 2 жыл бұрын

Sir please creat a chit fund 20 members

@Aceralkhafaji 4 жыл бұрын

Where is the link???

@thedatalabs 4 жыл бұрын

Link has been updated. Please refer the description box and download the file. Thanks!

@EoperacionalFluidma 3 ай бұрын

I have a problem can someone help me ? When I make my first answer everything its okey but with the second I am having Trouble because it erased the first answer, do someone know how to solve that kind of problem?