Hi!
I understand that there is a tutorial on how to input form to get data and store it in another tab in excel using VBA. However, my office sharepoint does not allow us to use macro instead can it be created using formula?
Thank you!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Create input form to get data and store it in another tab
0
Discussion
Gred
I'll try to look at that later today when I get to my PC. You can create forms without VBA but it depends what you're trying to do.
Did you see my revised answer on Vlookup and data validation? Is your idea to expand on that?
I'll try to look at that later today when I get to my PC. You can create forms without VBA but it depends what you're trying to do.
Did you see my revised answer on Vlookup and data validation? Is your idea to expand on that?
John_Ru (rep: 6142) Jul 25, '23 at 5:50 am
Hi.
No. This is a new worksheet. Coz I'm working on a database which will be put in sharepoint and macros can't works.
if I'm using excel form, yes it can save all the datas entered but it's not user friendly where each time a user need to key in they have to open tat form.
seek ur kind help on this.
No. This is a new worksheet. Coz I'm working on a database which will be put in sharepoint and macros can't works.
if I'm using excel form, yes it can save all the datas entered but it's not user friendly where each time a user need to key in they have to open tat form.
seek ur kind help on this.
Gred Jul 25, '23 at 6:02 am
Understood but kindly see the other Answer I posted earlier today Macro formula not working and - if it helps- mark it as Selected (in accordance with the Rules of the Forum). It's the only tangible "reward" I get for helping anyone.
John_Ru (rep: 6142) Jul 25, '23 at 6:11 am
Okay, I have a good solution for you (no macros) but don't have time to write it up. (Think it will work on Sharepoint but I don't have access to one to test). I'll do that explanation and provide an answer later today hopefully but only after you respond on the point above.
John_Ru (rep: 6142) Jul 25, '23 at 7:15 am