Loop writings from textboxes to arrays to ranges and then display the ranges in textboxes

[Falkirk]

Third time is the charm You guys have been very helpful so far..

This is for a project in Introduction to IT in Manufacturing.

I have a Bar/Hotel with 9 rooms and each room can have 6 occupants. Each room has a range(vertical) named Room1, Room2 and so on

The first part of my question is for the checkin:

the strRoomCount is a global variabel containing the room number currently activated/clicked

Please Login or Register  to view this content.

And so it goes on for all 9 rooms... which seems a bit silly

I have tried to rewrite that to:

Please Login or Register  to view this content.

The second part is closely related. Here I am writing the already populated range to the TextBoxes upon entering the room overview form in order to see who has been checked in.

Like this:

Please Login or Register  to view this content.

And that continued for an eternity, cell by cell...

My attempt at this is as follows:

Please Login or Register  to view this content.

[pjwhitfield]

Sorry, are you saying that what youve written isnt working? What is the query?

[Falkirk]

Yes exactly - and the error is before loading the userform. So I can't really see where the error is.

[pjwhitfield]

what exactly is the error though? and have you stepped through the code to see where it fails?

[Falkirk]

Run-time error '13': Type Mismatch

Can't really step through, as it returns that erroe immediately.

[pjwhitfield]

Without seeing the workbook its very difficult to even give a thought on where the error is. Type Mismatch is a fairly straight forward error to correct when you can see the code.