Đang Thực Hiện

Visual Basic Excel Userform coding

I require some VBA coding to achieve the following:

Outline:

1) A user opens a userform in Excel and fills out the answers to the questions in the userform.

2) A "submit" button on the userform is clicked and the answers are sent to a database on a dedicated worksheet.

3) The answers submitted must be automatically assigned a unique number identification within the database (see attachment for clarification)

4) In the event that a user is unable to answer all the questions in one go, there must be a method to edit / add information to a previously submitted entry.

These thoughts will provide further guidance:

1) I would like the database worksheet to be hidden from the user and password protected. I do have the coding required to do this so not to worry if this is not achieved.

2) It would be nice to have a prompt after clicking on the "submit" button: Something like "Are you sure you would like to submit your answers to the database?" Also, clearing the userform after submission, so another user can answer the questions immediately after.

3) I have attached a method of doing this. I don't know if it's the best but at least it gives an idea of what I'm after.

4)This is what I am really stuck on. Imagine the user gets to question 3 and realizes that he / she doesn't have the answer. I would effectively like them to be able to submit what they have filled in, go and find the answer, come back, retrieve the partially completed userform and fill in the rest of the answers.

I am imagining perhaps an "edit" button somewhere, where a user finds their previous entry via the unique identifier and can fill in and adjust the answers to the questions as necessary, then submit the update. NOTE: I don't want it to create a new entry with a new unique identifier number, just an update on the previously completed one.

Kỹ năng: Quản trị cơ sở dữ liệu, Excel, Visual Basic

Xem thêm: userform database excel, what is coding, what can coding do, password protected excel, excel 16, coding event, excel userform database, excel userform submit button, what is vba in excel, find in vba, Visual Basic Excel, visual basic edit, excel visual basic, excel password, Excel and VBA, database required in excel, create excel worksheet, excel database visual basic, excel submit, vba update excel, coding visual basic excel, visual basic excel coding, basic vba coding, visual basic database excel database, add vba password

Về Bên Thuê:
( 1 nhận xét ) Loughborough, United Kingdom

Mã Dự Án: #1722915

Đã trao cho:

danielgpratidya

Hi, don't wait anymore, get it in your pmb.

£50 GBP trong 1 ngày
(84 Đánh Giá)
5.6

18 freelancer đang chào giá trung bình £140 cho công việc này

bharanisrihari

Hello, Excel VBA expert here. I've done a number of similar projects like this. Please check PM for details. Thanks!

£200 GBP trong 5 ngày
(59 Đánh Giá)
6.3
nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b Thêm

£250 GBP trong 5 ngày
(40 Đánh Giá)
5.6
srinichal

let us discuss further

£250 GBP trong 8 ngày
(30 Đánh Giá)
5.5
mrbrave

Hi...This projects seems to be simple and I can do it in few hours without any bug.I have over 7 years of VBA [url removed, login to view] can check my history, I have done all projects for Excel VBA.

£110 GBP trong 1 ngày
(83 Đánh Giá)
5.5
FIBIN

Hi, I have a similar project done before. Please find the working sample attached with PM. I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I am int Thêm

£40 GBP trong 2 ngày
(43 Đánh Giá)
5.3
MDavidCrompton

Hi, I have worked on conversion, manipulation and analysis of Excel for 30 years and have completed several freelancer projects, PLEASE CHECK FEEDBACK. I have the solution to this. I am UK based, on GMT time, available Thêm

£30 GBP trong 1 ngày
(21 Đánh Giá)
5.1
KellogITSolution

Hello Me an Ms-Excel Expert working on MS-Excel & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Excel Projects and can provide u sample copi Thêm

£30 GBP trong 2 ngày
(15 Đánh Giá)
4.4
mike25

Hi - some remarks via your inbox. Mike

£250 GBP trong 15 ngày
(14 Đánh Giá)
4.3
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I have designed new work flow for you in PM.

£45 GBP trong 1 ngày
(13 Đánh Giá)
3.8
expertatwork

We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.

£30 GBP trong 3 ngày
(16 Đánh Giá)
3.6
subramaniankv

Hello, Thanks for the detailed requirement on this project. Since all requirements are straight forward, I would be able to complete this within a day.

£40 GBP trong 1 ngày
(8 Đánh Giá)
2.1
emddarn

I have made almost same type of macro before. Please contact me if you want to check that work.

£50 GBP trong 2 ngày
(0 Đánh Giá)
0.0
HvGSW03m4

Custom software development - <b><i>Removed by Admin</i></b>

£250 GBP trong 1 ngày
(0 Đánh Giá)
0.0
satheeshcad

Hi this is satheesh. i have experience in excel macro creation. I gone through your attachement. i can do this job in Excel VB code. i ready to discuss with you about cost and delivery time.

£250 GBP trong 10 ngày
(0 Đánh Giá)
0.0
kudhi

I can easily implement this on time.

£200 GBP trong 3 ngày
(0 Đánh Giá)
0.0
FAlgabaM

We advice to you a process in Visual Basic 2010 linking Excel and interchanged data in MSAcces. We are a litlle company from Central America and we will glad to make business between. More than 35 year of experienced Thêm

£240 GBP trong 5 ngày
(0 Đánh Giá)
0.0
prakashsax

Hi Please check the PM it suits your requirements.

£200 GBP trong 3 ngày
(0 Đánh Giá)
0.0