Wolfie
07-13-2014, 11:20 AM
Hello
I'am new to this Forum and am looking for some help with a workbook used for booking desks at work.
The work book has a Userform Calendar that was used to book desks in advance to another
Useform, "Second Floor". This works great
However Recently we acquired two other floors and have several more
desks available, I have added two more userforns to the workbook
to book desks on the other two floors, just copying the VBA code from the 2nd Floor to the new Ground and First floor Userforms.
The trouble is the Userform for the 2nd floor still works great, but the Userforms for the Ground and First Floors allow one booking of a desk and then stops working. My knowledge of VBA is not particularly good.
Is anyone able to take a look and see why the Ground and First Floor Userforms wont work , It would be greatly appreciated.
I have attached a copy of the Workbook. The password for Overwrites is "Kate"
Many thanks for any help in advance
Wolfie
I'am new to this Forum and am looking for some help with a workbook used for booking desks at work.
The work book has a Userform Calendar that was used to book desks in advance to another
Useform, "Second Floor". This works great
However Recently we acquired two other floors and have several more
desks available, I have added two more userforns to the workbook
to book desks on the other two floors, just copying the VBA code from the 2nd Floor to the new Ground and First floor Userforms.
The trouble is the Userform for the 2nd floor still works great, but the Userforms for the Ground and First Floors allow one booking of a desk and then stops working. My knowledge of VBA is not particularly good.
Is anyone able to take a look and see why the Ground and First Floor Userforms wont work , It would be greatly appreciated.
I have attached a copy of the Workbook. The password for Overwrites is "Kate"
Many thanks for any help in advance
Wolfie