Home
Creators
Search Recent Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

Dynamic Userforms Update [Gold & Silver] (Patreon)

Published:
2022-01-10 12:15:00
Edited:
2026-01-02 10:56:42
Imported:
2026-06

Downloads

Content

Hello Members!

In this week’s Feature, Fix, or Focus, we take last week’s Dynamic Userforms training.

Here are the updates I made for this training:

· Add New Record requested by Bricena Miguel, Fernando Lopez, Joe B, & Larry Duffie

· Delete Record  requested by Ian H and Larry Duffie

· Dynamic Combo Box requested by Fernando Escalera Lopez

· Dynamic Text Box Height requested by Mbobo Phiri

· List Box Total requested by Fernando Lopez

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Make sure to view the brand new and updated training and download the updated workbook in the attachments below.

As always, great to have you here, and thanks so much for your support.

Comments

Excel For Freelancers

Hi and thanks, it would be difficult to help unless we see the screenshots of thos errors. Also make sure you have watched the entire training video to help you ddebug those errors. Please post screenshots of your issues in our Excel For Freelancers Facebook Group here: http://bit.ly/groupexcel I hope this helps and thanks so much.

Excel For Freelancers

Feel free to email me the pictures of the issue and I can take a look (Randy@ExcelForFreelancers.com )

Excel For Freelancers

HI and thanks this probably means the "BackPic" file path is incorrect You can view the BackPic value by adding Debug.Print BackPic above the line of code that is causing the error then checking the immediate window for the value, there is an incorrect path most likely

Kyp

Thank you sir!

Larry Duffie

Can't wait to try it out. Thanks.

ian h

Hello Randy, i see you made awesome updates. But i see my request wasn't added :( I still can't remove items from the Listbox (as i requested :) ) You can only delete records from the sheet itself. Any solutions? Thanks

Joe B

Excellent updates!! Is there a way to update the delete feature so that you can undelete too if needed? Essentially having the deleted rows added to a separate "deleted rows sheet". This would allow to undo a delete (ie restore).

Mohamed Asstitou

Great updates! Is it possible to move a hole row to a next sheet, when a recuirt field in the form is filled.

Excel For Freelancers

HI Ian, the ListBox results are based on a filter (Such as Invoice # or Customer ID). To remove items you would first have to change/modify the source data. I hope this helps and thanks so much.

Excel For Freelancers

Hi Joe, Yes it is certainly possible with an Archive Table/Database. Records deleted are moved to an archive database and from that database they can then be restored to their original location as long as within that database you include the original sheet name. I hope this helps and thanks so much.

Excel For Freelancers

HI Mohamed, you can create another database and based on data values entered by the user, you can save it in any specific database, however the # of columns should be the same if possible. Make sure that a record only has one original database in which it is stored. You are then free to display this data on any sheet. I hope this helps and thanks very much.

fernando escalera lopez

Otra súper mejora seria que en la list box ya que se agregó un total que se subieran varios totales si existen columnas numéricas

Mohamed Asstitou

Hi Randy. I played with the file and when I indicate that a specific column must only contain numbers, the vba gives an error. I tried to add an new textbox in te formula but it won't work. Do you have a solution, like more types of fields in the form. The combobox was one. Maybe extra numericfield and checkboxes

Excel For Freelancers

Hi Fernando, certainly this is possible. Please download it, customize it and let me know how you achieved this. Thanks so much

Excel For Freelancers

Hi Mohamed, you can test for additional data validation options (In the above we only test for a formula). If you test for additional rules, you can then use those same rules to test the text box values. I hope this helps and thanks so much.

Glen Taylor

Great Update Love It. I did find an error in the setup sheet code if the sheet you are loading has more than 1 data table on it the table headers are added from the last table

Excel For Freelancers

Hi Glenn, thanks for the feedback and glad you enjoyed it. I think we would have to set a column limit based on a single table, however in the applications I design i keep it to a single table, except for advanced filter criteria and results, So if you stay consistent with your table design, and allow for max # of columns, you should be good. I hope this helps and thanks so much.

Glen Taylor

Thanks I will give it a try using 1 table per sheet

Glen Taylor

I found my issue and works. I found that if you set the wrong picture path (eg picture path of demo) there is no check and system crash. I have a suggestion to maybe setup the RecGrp and images on setup page . If your new sheet does not have RecGrp copy and paste from setup sheet

Excel For Freelancers

Hi Glen, thanks for the feedback and glad you were able to get it rectified. I will make some adjustments to the code so this does not happen in the future. Thanks again

Glen Taylor

Hi Randy. Would it be possible when creating the userform and the cell has a formula in it that the form could be loaded with that formula or have it calculate or protect entry of the form textbox

Excel For Freelancers

Hi Glen, when loading the form, the value/ result of the formula would be loaded without issue. However when saving you can add a caviat If statement, perhaps check for the cell value that starts with an "=" and if it does then do not replace the contents. This would preserve the formula. I hope this helps and thanks so much.

Glen Taylor

Hi Randy. One last thing would it be possible to add to the setup sheet the option to save the created userform and controls to allow some vba error checking etc. Would act like a small data form app but allow for vba changes, checks, validation etc

Excel For Freelancers

Hi Glen, certainly, anything is possible. Since I have already completed the update on this one., feel free to download it and customize it however you like

Wilfred Thode

Hi Randy, it is possible to put the listbox selected item on the label caption ?

Excel For Freelancers

Yes i am sure it is. You can use the listbox change event along with the listbox item # to determine which item was selected or the value of that item. You can then apply this value in VBA as the value of the label. I hope this helps and thanks so much.

Wilfred Thode

.caption = sheets(Linkedsht).listbox.selecteditem.value have an error 438