HI,
Thanks for looking at my query. Its really urgent and please help me.
I created a interactive userform. When you open the excel , it will automatically open the userform in which you can input the data which will store in the spreadsheet. I done with that and its working good.
My trouble is, i would like to search and edit based on some criteria. That is in my spreadsheet , if i give the week commencing and week ending , it should automatically pull up all other information and i should able to edit those information.
Please check the attachment
Please help me,
INTERACTIVE USERFORM URGENTTTTTTTT
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
INTERACTIVE USERFORM URGENTTTTTTTT
You do not have the required permissions to view the files attached to this post.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: INTERACTIVE USERFORM URGENTTTTTTTT
Hi Krishnaa,
Welcome to Eileen's lounge.
I'll have a look and see what can be done...
Welcome to Eileen's lounge.
I'll have a look and see what can be done...
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: INTERACTIVE USERFORM URGENTTTTTTTT
Thank you so much
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: INTERACTIVE USERFORM URGENTTTTTTTT
See if this is what you are looking for...
You can tweak the code and add additional cosmetics as needed.
I trust the basic coding will provide you the momentum to task this forward.
You can tweak the code and add additional cosmetics as needed.
I trust the basic coding will provide you the momentum to task this forward.
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: INTERACTIVE USERFORM URGENTTTTTTTT
Thank you so much.
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: INTERACTIVE USERFORM URGENTTTTTTTT
Brilliant Rudi. Thank you so much for your help. I request you to help. Apply filter concept is brilliant. Once i click apply filter in the EDIT userform, i should able to get other data like MAchine name, pg number, TPM number,etc for the corresponding date to the EDIT userform automatically in which i should able to edit it.
Please help
thanks in advance
Please help
thanks in advance
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: INTERACTIVE USERFORM URGENTTTTTTTT
Thank you so much Rudi. Excellent job. I think i need some more help from you please. When i click edit userform, when i filter date using apply filter, can you make all other data like Machine name, TPM number, PG number,etc for the respective date to be visible in the EDIT userform ,in such a way i should able to edit in that EDIT userform itself.
Please help me
Thanks
Please help me
Thanks
-
- 2StarLounger
- Posts: 179
- Joined: 30 Sep 2014, 15:18
Re: INTERACTIVE USERFORM URGENTTTTTTTT
Hi Rudy,
Thank you so much for your help. Brilliant work. If you dont mind can u please help me further? The code which you wrote is brillian and i would like to get the information from the spreadsheet to EDIT userform and i would like to see those information in my EDIT userform once i click apply filter option. If you dont mind can you please help me out.
Example:
Once you select the date, after clicking apply filter, It should automatically pull all the information (like Machine name, TPM number,etc) for the corresponding date into EDIT userform.
Thanks,
kind Regards
krish
Thank you so much for your help. Brilliant work. If you dont mind can u please help me further? The code which you wrote is brillian and i would like to get the information from the spreadsheet to EDIT userform and i would like to see those information in my EDIT userform once i click apply filter option. If you dont mind can you please help me out.
Example:
Once you select the date, after clicking apply filter, It should automatically pull all the information (like Machine name, TPM number,etc) for the corresponding date into EDIT userform.
Thanks,
kind Regards
krish
You do not have the required permissions to view the files attached to this post.