hi,
I have close to zero experience with VBA, however I understand excel relatively well.
I have followed a room booking system tutorial from pconline learning (which I have attached below). However, the "edit booking" macro/button was not covered and I was wondering if anyone had any idea what coding would be required?
In the "edit booking" button I currently have coding which I found online from another user from this website, however the code doesn't edit the data, it instead appears to simply clear the date inputted in the above textboxes whilst retaining the date in the separate sheet.
I would like the "edit booking" button to allow me to click on a cell with a booked user, look up his information (using the currently working "look up" button), and then change his data in the spreadsheet, for example move the user from room 5 to 10, or change his status from unconfirmed to confirmed.
I've attached images below and would be grateful for any help
I have close to zero experience with VBA, however I understand excel relatively well.
I have followed a room booking system tutorial from pconline learning (which I have attached below). However, the "edit booking" macro/button was not covered and I was wondering if anyone had any idea what coding would be required?
In the "edit booking" button I currently have coding which I found online from another user from this website, however the code doesn't edit the data, it instead appears to simply clear the date inputted in the above textboxes whilst retaining the date in the separate sheet.
I would like the "edit booking" button to allow me to click on a cell with a booked user, look up his information (using the currently working "look up" button), and then change his data in the spreadsheet, for example move the user from room 5 to 10, or change his status from unconfirmed to confirmed.
I've attached images below and would be grateful for any help
