Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform query
Hi,
I have a cancelled appointments userform, if someone cancels their appointment the user will enter their name, appt time etc in a userform and this info is then stored into a cancellations sheet in the spreadsheet, this bit is fine. what i want to do next is if this info is enterted into the cancellations sheet the code should somehow recognise the info being put in and delete this info in the appointments sheet. so this info would already have been in an appointments sheet but because now its cancelled it then goes into a seperate sheet called cancelled appts. but i would now like for the code to delete the exact same info from the appointments sheet and if its possible alert the user that an appointment slot is now available and say the time/say of the cancellation. i dont want this bit to be manual because at the moment when a cancellation is made the user enters the stuff into the cancellation sheet but then has to manually search that record in the appointments sheets and mark it as cancelled. is this atol possible? i checked some websites as recommended but didnt find anything like this. thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform - Query Help Please | Excel Programming | |||
Another UserForm query | Excel Programming | |||
Another UserForm query | Excel Programming | |||
reloading a userform query | Excel Programming | |||
Userform text box query?? | Excel Programming |