Hi, I am trying to make multiple feild in a form required before the form can be save and sent back to me as an attachment. I am very new to this much of a detailed formula, any help would be greatly appriciated.
The cells that I need to have required are E3, M3, R3, W3, E6, V6, E7, V7, V8, and E9
Please help
Thank you very much
Try:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This worked great, only problem is I need to be ablke to send a blank one out to my team. Is there a way to save it as a template so I can send it over blank and to do a "save as" they have to fill in everything?
Interesting problem!!
To save the blank template:
In the visual basic editor, press Ctrl-G to view the immediates window.
In the immediates window, type:
then press enter.Please Login or Register to view this content.
Flick back to your workbook, and save it.
Go back to the VBE, and in the immediates window, enter:
Please Login or Register to view this content.
Sorted
Hi, thank you for your help, I have tried this and I still cannot save a blank template that I can send out for folks to use.... any idea what micht be wrong?
The method I described in post #4 should work.
Attach the file, I'll save it as a blank template and attach it back.
Thank you, I really appriciate it
Try the attached.
All I have done is exactly as I posted - opened your workbook, pasted the code into the ThisWorkbook module, disabled events, then saved. Please let me know how it works!
Thank you very much, it works wonderfully
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks