View Single Post
 
Old 05-19-2016, 09:43 AM
dan88 dan88 is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2016
Posts: 24
dan88 is on a distinguished road
Default Update Userform Captions, TextBoxes, Command buttons From Excel

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
Attached Images
File Type: png userform.png (4.5 KB, 21 views)
File Type: png Spreadsheet.png (7.1 KB, 21 views)
Reply With Quote