UserForm Caption Change

[mrdoctor]

Does anybody have any VBA code that would do the following.

I have data that is controlled by states
example: If I select State = Illinois I would like my Caption of my UserForm to say state of illinois
If I select state = Indiana I would like my Caption of my userform to say state of indiana
I am not looking to change the name of the UserForm Just the Caption Title on my Selections of states

Thanks

[royUK]

How do you select the state? If it's from a ComboBox on the UserForm

Please Login or Register  to view this content.

[mrdoctor]

Thanks Roy, yes to answer your question it was from a combobox. Appreciate your HELP it done what I needed Thanks Again.

[royUK]

Please mark the thread as solved