Macro needed for Booking System

[geniechua]

Hi all,

I chanced upon this thread http://www.excelforum.com/excel-gene...html?p=2879648 while working on a similar project based on the template provided here: http://exceltemplate.net/calendar/ca...l-reservations

What I want now is to show when the cell is highlighted the name of the person who has booked the room at that time.

Anyone knows how to write this macro?

Thanks in advance!

[geniechua]

any help please???

[geniechua]

Bump no response

[geniechua]

last bump...

[royUK]

You need to add your workbook

[geniechua]

Sorry for the delay...here's my workbook

Room booking.xls

[geniechua]

any kind souls who can share some thoughts please???

[jindon]

Different method.

See if this works.

[geniechua]

Hi jindon,

Thanks for your reply!!! I see you have done something (though not exactly sure what) to the sheet such that the formula doesn't show in the "Room Availability Table".

However, what I actually want is for the name of the person who has booked the room at that time to show up when I hover my mouse over the cell which is highlighted.

Take your worksheet for example. If I key in 01/01/12, some cells will be highlighted red. If I were to hover my mouse over to say cell D7, I'd like John's name to appear. If there are double reservations, I would like both names to appear and if the reservation is cancelled and the cell turns back to blue then nothing should appear when I hover my mouse over the cell.

Hope I'm making myself clear?

[jindon]

Try the attached

[geniechua]

Hi jindon,

This is EXACTLY what I want!!!

However, as far as I can see, you have pasted a macro in Module 1...are there any other macros involved?

Also I already have a macro in Module 1...can I paste your macro below the existing macro or should I insert another Module?

Here's my existing macro:

Please Login or Register  to view this content.

[jindon]

Hi jindon,

This is EXACTLY what I want!!!

However, as far as I can see, you have pasted a macro in Module 1...are there any other macros involved?

Also I already have a macro in Module 1...can I paste your macro below the existing macro or should I insert another Module?

Yes and you also have a codes in both sheets;
- Availability has Worksheet_Change event code
- Room Reservation has Worksheet_Deactivate event code

both is calling "test" sub procedure.
So, if any change in the range that effect to the result, it will update automatically.

Check them.

[geniechua]

Hi jindon,

I've tried the code on the test workbook (i.e. the workbook posted earlier) and it works fine but when I tried to use it on my actual workbook (with additional macros) I got all sorts of weird errors!

Here's the actual workbook...

Room booking.xls

I've made all the necessary changes (i.e. worksheet / cell reference) but still can't get it to work...what's going on???

[geniechua]

Hi jindon,

While waiting for your reply, I have tried using your file and making some amendments to suit my requirements. However, I'm stuck at 3 items:

1. For View; Make Reservation sheet, I want to switch the columns for "Room" and "Date" such that "Date" is in column B and "Room" is in column C. I've tried to tweak the codes but nothing works.

2. I realised that the code won't work if there is an empty row in between 2 room reservations. Can the macros be tweaked such that it would work even if there are empty rows in between?

3. Is there any reason why the file size has become so big???

Here's what I've changed so far using your file. Appreciate your advice!

New_Room bookingVBA.zip

[jindon]

I found quite a few posts providing sample workshbook that has different sheet layouts from the actual workbook.

Why????

Now you have different sheet names, different data range, different output layouts and merged cell....

If you think you can adjust the code for yourself, you should be able to write a code for yourself from the scratch already.

try the attached to see if it works.

[geniechua]

Hi jindon,

So sorry for the trouble and confusion...there is a difference in the worksheets as I was working on the layout of the system while waiting for advice on the comments macros...

I thought that the workbook I posted yesterday was quite close to what I want...only that I would like the "Date" column in "View; Make Reservation" sheet to be at column B instead of C and the "Room" column to be in column C instead of B.

I'm not sure what you have changed in the workbook you last uploaded but the "Room" column is still in column B and the "Date" column is still in column C...would you be able to switch the 2 columns and edit the macro so that it works?

Thanks so much for your patience and help so far!

[geniechua]

Hi jindon,

For some strange reasons, my earlier reply can't seem to be posted in the forum...

In any case, so sorry for the trouble and confusion...there is a difference in the worksheets as I was working on the layout of the system while waiting for advice on the comments macros...

I thought that the workbook I posted yesterday was quite close to what I want...only that I would like the "Date" column in "View; Make Reservation" sheet to be at column B instead of C and the "Room" column to be in column C instead of B.

I'm not sure what you have changed in the workbook you last uploaded but the "Room" column is still in column B and the "Date" column is still in column C...would you be able to switch the 2 columns and edit the macro so that it works?

Thanks so much for your patience and help so far!

[krisime]

I'm doing a hotel booking. however, i have problems: its taking too slow to update.... any help?

[naum2]

hi all,plz provide password to view code
re
regards

[naum2]

hi plz provide password for the excel to view code
many thanks

[StormNorm]

Has anyone created the macro code for the edit existing booking Eaton Trevor booking room program -which is missing in his tutorial?

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread