I made my firt Userform. But i can't get the hang of writing the VBA with it.
I made a Userform1 with:
ComboBox 1 to 25
TextBox 1 to 3
2 buttons (Ok, Annuleren)
When pusht Ok i like to write a code that copy's all the ComboBoxes en the Textboxes in the same row (b,c,d,e,f,...) under the first empty cel in collum B. Also all boxes has to be fild accapt textbox 1.
When pust Annuleren is whant to delete everyting and hide the Userform.
Hello Frigide,
I changed the title of your post to reflect your question.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Frigide, CONGRATULATIONS.I made my firt Userform
About your query, this is a far to general description to work with.
Post your workbook with userform in it so we can check Sheetnames, Control names, what goes where, which formats to apply to give you to the point advice on how to proceed.
also there are tig threads here regarding userforms and how to write to worksheet. I'm confident you can get some useful information there too.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
This is the userform.
When pusht Ok i like to write a code that copy's all the ComboBoxes en the Textboxes in the same row (b,c,d,e,f,...) under the first empty cel in collum B. Also all boxes has to be fild accept textbox 1.
Give the attached a try, only combos 4 - 7 are loaded, chose from them and press OK, this should save to Sheet1.
It is only a brief demo using Tables for data storage, the combos list is array loaded a method more stable than rowsource.
Start your code with 'Option Explicit' this will force you to declare your variables, this proves beneficial, always run debug.
There is a small routine in a module 'ClearForm' this would be used many times as you develop your application.
happy coding.
torachan.
table text font color needs setting to black - not visible as white by mistake.
Last edited by torachan; 11-18-2019 at 01:08 PM. Reason: cannot see text
Let's start with this.
Please Login or Register to view this content.
Thanks! I was programming line for line. I find it difficult to do the For i = think. Ones again, thanks!!
you're welcome and thanks for rep+.
In the sample it is working fine. I changes the code a bit and made a sheet whit a nice looking collers and rows. Now the code is not working anymore.
This is de code where it is going wrong. I dod nothing to fancy. Only toke the first 3 line for some headers!
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Frigide; 11-18-2019 at 04:36 PM.
If you find the time maybe you van look for me?
According to your new example file in Post#10.
Please Login or Register to view this content.
Works like a charm thanks again!
Glad to help and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks