×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Arranging seats using a macro

Arranging seats using a macro

Arranging seats using a macro

(OP)
Hi,

I need to arrange seats based on pitch. This is being done in 2D. I have the seat contours as an instance. This has to start at certain point (say X = 50.0) and be incremented from there onwards. The seat pitch is not constant. I was looking to create a user form which first asks the user to input the number of seats and then displays another user form with columns to the number of seats entered, to enter different pitches between seats. How can I do this using a macro.

Thank you!

RE: Arranging seats using a macro

Hi,

Just for my curiosity, a fixed number of seats or it can be variable? How many columns? Is it in an aircraft I suppose, yes? How many on left, on right? On center also?

Pitch is same along the column or can be different along the columns starting with a specific point (or in different zones)?

It seems to be a problem of optimization, final goal is to have as much seats is possible or ? In real life in an aircraft you have a lot of restrictions...

Regards
Fernando

https://picasaweb.google.com/102257836106335725208
https://picasaweb.google.com/103462806772634246699...

RE: Arranging seats using a macro

(OP)
Hi ferdo,

It is for the aircraft. Left hand side and right hand side may sometimes be different, but it will mostly be same. Right hand side will start at a different x station. Pitch may vary from one row to another, but the distance column wise will be same. I don't mind entering pitch value for each row separately, but I am looking at something which asks repeatedly for pitch values based on the number of rows I select for each side (LH & RH).

Thank you

RE: Arranging seats using a macro

you could have incorporated the pitch same in userform and then read from it as you have created it.

Whats the point in entering each pitch aging and again.
Perhaps a userform with proper description of rows and columns along with pitch will be more than sufficient.
you can have the userform to enter all pitches at one shot.

First Populate a listbox or combobox with some default pitch.
1. User selects a row in a listbox or combobox
2. Below combo box you can insert some textboxes for entering pitch.
3. Once pitch entered, detect the change and update the new pitch.
4. At last click OK to create the arrangement based on the pitch entered and with some default pitch.

Regards,
Maddy

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources