Hi all,
I hope you can help me.
How can I dynamically change the Label name and the TextBox name on a UserForm based on a TRUE/FALSE criteria in a List?
This is what I would like to do: If in my Admin sheet of my workbook, Name1 (column A) = TRUE (column B) then TextBox1 and Label1 in my UserForm2 dynamically change to 'Name1'
thank you in advance!
You want to change the names of the controls dynamically at run time?
If posting code please use code tags, see here.
When you launch the UserForm (UserForm_Initialize), it checks what the TextBox value should be. i am trying to create Admin settings/System Defaults
To dynamically rename controls on a form you would need to program to the VBE and I'm not sure that's possible at runtime.
Actually I should clarify that, you could have something like this in the Initialize event,
but you wouldn't be able to refer to the textbox by it's 'new' name.
Please Login or Register to view this content.
I am not too sure I understand.
Will I be able to save the value that is entered in the dynamic textbox according to its name? I.e., if the textbox = textbox1, the data saves as textbox1.Value, when the textbox = WhatEver, it saves as WhatEver.Value
Actually, I had a mistake when testing - put the code in the wrong userform event.
If you add this code to UserForm2 you'll get an error message.
Please Login or Register to view this content.
Last edited by Norie; 01-20-2015 at 08:26 AM.
Hi Norie
i am losti do get an error.
Do you have any suggestions perhaps?
I'm not really sure what you are trying to do.
Why do you want/need to rename the controls?
Couldn't you use their Tag property to store the username?
i have never attempted to do what i am trying.
I have 10 possible field names, but at any given time, only 6 might be active on the UserForm (sort of like admin system configuration, where an administrator decides which fields are active).
So, on the user form I would have 6 fields that need to dynamically change their names based on the admin settings.
And, based on the textbox name, the databse will be updated with that data in the appropriate column. Does this makes sense?
Why not use a 2 column listbox dynamically populated with the appropriate fields?
The first column would have the field name and the second column would be for the field value.
The user could enter the field value for the selected field via a textbox.
Intrigued...
Could you share an example perhaps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks