User Form

[JSH720]

I want to create a user input form that is an add in and works similar to the excel built in except for 1) unlimited columns 2) can grow and shrink on all input boxes

in other words I can add the adding macro to any ss. It will use the header names to create the labels and boxes snd the formatting of the items in the column.

Thanks

 

[dmt32]

Hi,
to do what you want would be a lot of work but fortunately, someone has already done in.
John Walkenbach created an enhanced Data Form AddIn & is available for free download (Free Downloads for Microsoft Office) item 4 on the list.

Note: There seems to be problems accessing the site & if you cannot access, Maybe ask another here if they have a copy they can post for you

Dave

 

[JSH720]

Thank you I will definitely check it out! It is super frustrating and error prone to input into these mega spreadsheets