VBA forms

[nbkek2p]

Hi Mr. Excel,

I am making a VBA form in excel. In this form i am gone use three text box and two button(basic data entry form). Now this form will be used by 10 people working in same office and connected via LAN. Now my question is that is there any way i can connect all the 10 person form to one excel file. For ex in a day everyone has to make various entry in the form and i want that all those entries automatically updates in one sheet which is with my desktop. So at the end of the day i can run a report which can give me consolidate report for everyone. Also would like to know how can i make visible only form and not the excel while doing the entries???

Hope you got the question. Let me know if you need anymore information on this.

Thanks in advance.

 

[bensonsearch]

Hi,
If I understand you have two questions?
1. can you hide excel and only have form - Yes
enter below code in worksheet open event

application.hide

as far as the 10 people using im going with yes, so long as they can access whereever the file is stored (and it is shared!)

I would advise putting into your code a save function whenever the user writes data. this would be one of your buttons i guess (add to sheet button). in the code put

ThisWorkbook.Save

hope this helps

 

[nbkek2p]

Thanks for the prompt reply.

In the first ans. if i use the given code then it is hiding excel and form both. Do i need to put some other code. What i want is whenever i click excel icon to open only VBA form get open and nothing else.

In the second one for shared do i need to place the file in some kind of share drive or there is any other coding in vba by which i can connect all the user to that one file. Currently in my workarea we have a LAN connection and everyone has a userid. So can i put some kind of code in excel so that data from that userid get stored in a single excel file which is at my desktop.

Again thanks for taking time to ans this query.

 

[bensonsearch]

Hi,

with 1 try

excel.application.hide

the second would need to be a shared drive or space.

also with the first make sure there is some way of re showing the excel app (a secret button or something) otherwise hard to edit the form again

 

[nbkek2p]

Thanks for the help. Ya it works great for the first part.

For second part is there any way or coding that if i enter data on my user form and that data gets uploaded directly on the sharepoint (i.e. any web sharepoint which is used within the domain).

Thanks in advance.

 

[bensonsearch]

Hi im not sure i understand the second part. the form is run on top of your excel file. it can update the file (or other files) from there no issues...

can you clarify what you need?