Update Userform Captions, TextBoxes, Command buttons From Excel

[dan88]

Hi,



userform experts please advise.

I am creating some userforms in word and it has a lot of command buttons, text boxes and labels

I was wondering if there was a way for me to map this out on an excel sheet,

Example attached


So that when I change the values in excel , I can run a macro to update.

Or I don't mind storing it in a word table - if that's a possibility

I am pretty new to userforms, so I'm not sure, what I should do apart from manually set every property which will take forever.

Advice very much appreciated.

dan