I am creating a Documentation tracker using a UserForm that I am teaching myself how to create.
I have added option buttons on my userform and the answers are going to the correct spot on the data sheet but It is displaying FALSE instead of the Answer I tried to program.
Below are the two areas that have to do with the option buttons.
Please Login or Register to view this content.
Last edited by bradfordahill; 04-14-2018 at 06:37 PM.
Remove these linesand replace withPlease Login or Register to view this content.Also move this linePlease Login or Register to view this content.To the very top of the module, before any codePlease Login or Register to view this content.
Thank You for responding. I applied your corrections and now the tracker is not displaying anything where before it was stating "FALSE". I am sure I am doing something incorrect. Below is how the entire code looks and keep in mind this is my first time creating a UserForm and everything I have done and know is from internet research.Originally Posted by Fluff13
Remove these linesand replace withPlease Login or Register to view this content.Also move this linePlease Login or Register to view this content.To the very top of the module, before any codePlease Login or Register to view this content.
Please Login or Register to view this content.
It needs to be likeWhere the line in red needs to be the first line in the modulePlease Login or Register to view this content.
Attaching a copy of the UserForm.
Unfortunately I am still unable to get your suggestions to work and I am sure I am just not understanding.
+*+*Attachment Removed+*+*
Last edited by bradfordahill; 04-16-2018 at 12:20 PM. Reason: Removing attachment
Thanks for the workbook.
Try replacing all your userform code with this
Please Login or Register to view this content.
Thank You - You are the bomb.com
Now I just need to get a VBA for dummies book.
You have made some classic mistakes.
I am attaching some sample Userforms for your perusal.
Meanwhile try this code:-
Please Login or Register to view this content.
These are my basic rules for Userform Design.
Rule 1. Never Rename your controls, It makes Coding Harder
The above code enters the numbers 1 to 100 in textboxes 1 to 100Please Login or Register to view this content.
How would you do that if each Textbox has a unique name?
Rule 2. Number Each Control with the Column Number of its Source Data.
The above code loads Textboxes 1 to 100 with the data in row 1, columns 1 to 100Please Login or Register to view this content.
The above code Stores Textboxes 1 to 100 in row 1, columns 1 to 100Please Login or Register to view this content.
Rule 3. You can have more than one control storing data to the same cell
or
reading data from the same cell
That is not a problem. As long as they are not the same type of control.
Eg. Textbox1, Combobox1, Label1 can all read / write to the same cell
Rule 4. You can use your Titles as the default text of a cell to avoid having labels
This makes your userforms cleaner.
Rule 5.
Do not make Multiple Read / Write actions between Excel and VBA.
Read / Write your data into an Array. Then Save that to excel, Or transfer the data to your Controls.
Last edited by mehmetcik; 04-16-2018 at 12:28 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank You - This seems to be much more advanced that I am currently as I do not know what most of what you typed means. However, I appreciate your response and samples and will most definitely look and review them to increase my knowledge base and apply to my current project.
Glad to help & thanks for the feedback
I have added Userform 23 to my samples to demonstrate the use of Arrays to read and write between Excel and VBA.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks