Help needed..Userform for excel

[praxado]

Hi thr...

I am new to VB and no idea how to code, this is where i'm hoping one of u might help me.

My problem:
I need a userform which updates data on sheet1 named banksData
1. Clmn A has to have a Unique ID given to each new entry - generated when user submits an entry
2. Clmn B has banks name in drop down, validation from sheet2 named banklist
3. Clmn C has Stage. This is a drop down too validation of stage 1-10
4. Clmn D has Status, here's the tricky part, this drop down is dependent on Clmn C "stage". Each stage has a set of Status. whn Stage 1 is selected, status a, b, c & d shows. stage 2, status e, f, g, h..and so on
5 Clmn E is a comment field: to type in comment.
6 Clmn F for date. I saw one outlook date button.

And a submit button to send these data and clean it for next entry.

Please help.

Thanks

 

[Tinbendr]

1. Clmn A has to have a Unique ID given to each new entry - generated when user submits an entry

Please give an example of ID number.

 

[praxado]

Please give an example of ID number.

Hi David,

Thanks for your reply.
The ID number is just a numeric tag for all the input data. For example 0001, 0002 and so on...

A
0001
0002

Thanks again for helping me
Regards,
Prasad

 

[Tinbendr]

Try this.

 

[praxado]

Try this.

Thanks a bunch David.. works like magic

Best Regards,
Prasad