Hello there, I have a couple of queries I am struggling with and I am after some assistance.
I have a "Data" tab with columns of data fields, and a user form which can Add to the next available row, and another user form which can find them via a drop down bringing back all of the fields into the user form. I want to basically use the 2nd form to be able to "update" data fields.
For example, I want the value of TextBox1 to change in the data if I change it in the userform and click update. The bit below where this is wrong is in the "currentrow" selection as this is not clearly defined- is there another way I can update the data using a vlookup function? The key reference field is called cboref and is a drop down in my user form e.g. if cboref has a match in my data and I click update then whatever I have in the user form for TextBox1.Text I want it to update the value in column 3 of that row where there is a match on cboref....
The second query I have is around row entries- I have a list of certain tasks which are due on different days e.g. every Monday, or monthly e.g. third wednesday of every month etc. I want some criteria which can look up the frequency of the task, match it to the data sheet and if the task before todays date has been marked as 100% complete in the 'progress' column, I want vba to automatically copy that row, paste it to the next available row in the data with the next date due (based on the frequency). I guess this could be tricky to code up and we may need something to check the days that the task is due![]()
Please Login or Register to view this content.
Kind regards
Bookmarks