Excel Form

[santosh.ghosh9999]

Hi All,

Wish you a very Happy New Year!!

I need to update a big excel using form, user should not directly enter into excel, instead he should be able to edit/add using a form, As this is a big excel user form not possible? Is there any other options like in MS-Access we have Form wizard.

Sample excel attached.

Plz. help

Thanks and regards

 

[Justin Greenwood]

For something like that I would use MS Access. If lots of users need to use it you can always distribute Microsoft Access Runtime to the users and link it all up.

 

[santosh.ghosh9999]

For something like that I would use MS Access. If lots of users need to use it you can always distribute Microsoft Access Runtime to the users and link it all up.

I have a restriction to stay with excel only.


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[Justin Greenwood]

You can with a VB script but its not advised as the code hides the application and if it crashes before unhiding the application the user's current and future Excel instance will remain hidden until someone goes into the VB console and resets it to True

 

[Marc L]

Hi !​

Sub Macro1()
'
' Macro recorded by The Noob Simulator
'

    Sheet2.Activate
    Sheet1.ShowDataForm
End Sub

Do you like it ? So thanks to click on bottom right Like !
​

 

[santosh.ghosh9999]

You can with a VB script but its not advised as the code hides the application and if it crashes before unhiding the application the user's current and future Excel instance will remain hidden until someone goes into the VB console and resets it to True

Could you please help with sample file

 

[Justin Greenwood]

I am not great with VBA but did find THIS for you. Hope it helps.

 

[Hui]

Santosh

I have sent you a conversation

 

[Hui]

How are the numbers in the Red subtotal lines calculated?
They are not averages or length weighted averages that I can see?

 

[Hui]

You want something like: