Creating User Form And Get Data Store In Another Sheet

[harukofumiyo]

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?

 

[vletm]

harukofumiyo​

# You should reply something to Your previous thread

Creating of User Form on Excelsheet

Hi i am trying to use excel to create a beautiful database (instead of using Access). i have a workbook with 3 tabs; GPEntryForm, GPResult and GPForm. In the GPEntryForm, this is the user form that user will key in. (1) However, how can i use the previous, next, save, delete and generate button...

chandoo.org

# Where did You explain in this thread - how should this work with formulas?

 

[Gredang]

harukofumiyo​

# You should reply something to Your previous thread

Creating of User Form on Excelsheet

Hi i am trying to use excel to create a beautiful database (instead of using Access). i have a workbook with 3 tabs; GPEntryForm, GPResult and GPForm. In the GPEntryForm, this is the user form that user will key in. (1) However, how can i use the previous, next, save, delete and generate button...

chandoo.org

# Where did You explain in this thread - how should this work with formulas?

Hi. I realized that this will need macro but sharepoint does not allow me to use it.

 

[vletm]

Gredang​

I've tried to ask harukofumiyo to do two things.
Are You harukofumiyo?
That thread has a reply and someone is waiting any comments.
Without answers, harukofumiyo could only wait.
( I'll later (after harukofumiyo's reply) delete replies from #2 to #4 (this). )