Search and edit data in a Userform

[flashdisk]

Hi i have a user form which inputs data to a worksheet

I want to have 2 tabs, one for adding data and one for amending data

the form is for users to update information hourly by selecting the date and time

Is there a way on the amend data tab to select the date and time which will then display the imputed data previously entered?

Please help

User form attached

[Tinbendr]

I would remove the date picker on the amend tab and use a combobox to display the dates/times from the volume page.

Combine the Date and Time to display as one item in the combobox.

Or You could add only unique dates to the first dropdown, then a second dropdown for times. (more code work)

Once the date/times is chosen, then populate the fields with the data from the sheet. When they press the Amend button, the data is written back.

Easy, right?

[flashdisk]

Hi Thanks for replying

Each day 12 rows of data will be updated hourly ranging from 8am-8pm

I would prefer a method where they select the date and then the time combo box will display all times that data has been updated.

Can someone please help with the coding for this as am fairly new to VBA?

[flashdisk]

please any help? userform is attached above

[Tinbendr]

This version pulls the data into the Amend tab. I've run out of time. I'll try to work on it more later.

[flashdisk]

Thank you so much for helping me Tinbendr, looks great so far

[Tinbendr]

OK, I think I have it, but be sure to test it thoroughly.

I had to go back and rewrite the code for storing the data in the combobox. I needed 11 elements, but cboxes only have 10. :P So I basically scrunched (scientific term) all the data into one variable. Then, I parse it out again as needed.

As it is written, if you make a change in the textboxes, press amend, the data will change on the sheet. But it you pick a different time, then go back to the one last edited, it will bring BACK the old data, because it's currently stored in the combobox. A small 'feature' that we can work out if need be.

[flashdisk]

Hi Tindendr, Thanks again, works perfect. With the Amend button i added a msgbox and then added unload userform1 to stop them from going back to select the time

Only issue im having now is trying to replicate the same codes for my other 2 amend tabs. I renamed the date and time box on the idle amend tab to txtAmendDate1 and cboxAmendTime1 to make replicating simpler but when i try to test the userform and click on the calendar it just comes up with a run time error. This is the code i used below

Please Login or Register  to view this content.

Sorry to keep bothering you but you have been amazingly helpful

[Tinbendr]

You'll have to change the properties of the combobox as well.

Column Count - 3 (Column 0 - the times. Column 1 for the data storage and Column 2 for the row number we got it from.)
Column Width - 72 pt;0 pt;0 pt (This keeps the scroll bar from appearing. 72 is also the Width property of the combobox.)
ListRows - 12 (You have 12 possible entries. Why scroll with only 8 in view?)
Rowsource - blank (You can't Clear a Rowsource list. Since we are loading the ACTUAL times, we don't need to bound it to a list.)

[flashdisk]

Worked , Thank you so much again, been amazingly helpfull