Unable to match Textbox comments in a Userform

[Ortz]

Hi Everyone

I'am hoping someone will be able to help me.

I have a Desk Booking Workbook that was used in our old office. Since we moved office I was tasked to alter it to match the new 1st floor we use in our new office. I was able to alter the userform so it reflects our new floor layout but my knowledge of VBA is very limited. I have tried to alter the code so that when booking a desk the users name appears in the correct textbox but I cannot see or workout why when I use it the names appear in the wrong desk. To be honest i dont know VBA very well at all and am scratching my head with this.

Can someone if they have the time have a look at the code and hopefully help put it right.

I have attached a copy of the workbook. The overwrite password is "Kate"

Thanks very much if someone can help with this

Ortz

[Sean Thomas]

I would like to help, but I don't quite understand how to use this form or what data you want to appear where.
Perhaps if you were to enter some data and show maybe a screen print with what it does I maybe able to help

[Ortz]

Hi Sean

Thanks for replying. I just noticed when I try to open the workbook from the site here it has a runtime error 91, but it opens fine on my PC.

When the workbook opens it displays the Userform as seen below:

a.jpg

When someone wants to book a desk they double click in the desk textbox they want to book which brings up this Frame

c.jpg

In the submit textbox they time in a comment such as the time they are booking the desk and when they press submit it enters that detail in the corresponding desk which then changes colour to red to show its booked as below.

b.jpg

But whats happening is , for example, if someone is wanting to book Desk 1, when they double click, enter details in the submit box in the frame its booking desk 4 not desk 1 and the remainder of the desks are not booking correctly. Hope that helps some Seam.

[Sean Thomas]

Hi,
I have updated the code.
Basically the textboxes were pulling the data from the wrong cells when submitting the data.

[Ortz]

Thats fantastic Sean, thank you very much.

Just so I have a better understanding, what part of the code was wrong and what needed to be changed, if you have time to explain.

Again thanks a lot Sean

Ortz

[Sean Thomas]

When ever a text box is double clicked it runs a procedure for that texbox.

Please Login or Register  to view this content.

This line determines the cell in the data sheet to either pull the value from or add the new value to.

Please Login or Register  to view this content.

in this case the 16 was a different number, so when you submitted it, it went to the wrong cell. So another part of the code would pull a different cell value in.
The .offset(0,16).address means if the active cell was A2 then it would be locating the address of the cell on the same row but 16 columns along.

Hope that helps.

[Ortz]

Thanks for that Sean

I see that now, thank you for the explanation.

Regards

Ortz