Allow Data Entry and Saving of Excel File, While Userform1 is in Open on the Worksheet!

[Rajeshkumar R]

Dear Experts,

With My limited knowledge in VBA, I am unable to Move Forward! Would need your support to modify below coding as per my Request.

Please Login or Register  to view this content.

When I double click on Range C2:V100 on worksheet “ProjectA 08Nov2016” There is a popup userform which demand User to enter data. And Those data are getting updated in “Changes Tracker Worksheet”.

In the Above Coding, After Active Sheet Gets Unprotected, Userform1 is Popping up in the, in the same worksheet.

However, Though Userform1 vbModeless I am still not able to Edit or Modify any Data on the Worksheet!

Request 1 :- How to do Enable accessing of worksheet (Add, Delete, Modify Etc.,) when Userform1 is Opened?

Request 2:- Useform1 should automatically close 60 Seconds from its get Pop up, What should be conding for the Same.

Need Your Valuable Suggestions on my above Request Please! Immediate support is Really Appreciated!

Thanks & Regards,
Rajeshkumar R

[BadlySpelledBuoy]

Request 1:
Add the part in red to this line of code:

Please Login or Register  to view this content.

Request 2:
What do you want to happen to the data recorded in the userform when it closes automatically? Save it somewhere or lose it?

BSB

[Rajeshkumar R]

Dear BadlySpelledBuoy,

Thanks for your kind Response! However, There are two Userform in my Worksheet. And I would want above Requstes (1&2) to be applied for "Userform1" not to the other one (Schedule_Changes_Tracker)!

In My Code I have already used "vbModeless" for Userform1, But I were not able to edit or access the worksheet!

Need your Extended support on the same!

Thanks & Regards,
Rajeshkumar R