Combobox help!

[Spiritseye]

Hi all,

I had populated a worksheet (vessels) with all relevant information

I had created a combobox on worksheet1 showing the names of vessels which is linked to the worksheet (vessels) (cell, A2)

Now, I would want, after choosing a combobox.value (name of vessel: eg. in cell A2). what is the code that would also get the other colomn information about the vessel in cell: B2 and C2 and transfer it all into a third worksheet?

Thanks!

[royUK]

Why use a ComboBox, Data Validation list & VLOOKUP require no VBA & simpler to use

[Spiritseye]

Hi Roy,

As i'm doing a simple program for the engineers (including myself) using excel.

The first worksheet is where the 'program' is run for the guys to input the data in.

After all the inputs, the information are then transfered to another worksheet (service report) where it will be printed out and filed.

The 3rd worksheet is the database of all the vessels information (cells: A2 = vessel name, B2 = callsign, C2 = equipment etc.)

I would like the value chosen (eg. Cell A2) in combobox on 1st worksheet to be transfered over to the service report worksheet together with the information related to cell A2 (eg. B2, C2).

Thanks!

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[Spiritseye]

Hi Roy,

I apologise for my limited knowledge in VBA excel programming.

A picture speaks a thousand words, so they say.

1) Worksheet1 is where engineers will use and input data in regards to the vessel.

2) ServiceReport worksheet is where the input data by the engineers are saved and will be use for printing

3) VesselDetail worksheet is where the vessels details are all located. It is only a database. Engineers will not need to use this page manually.

Anyway, regarding the Vessel Combobox (In Worksheet1), when the user chose VSLtest (name of vessel) and click next button command below the page, I would need all the vessel details stated in cells B2, C2 etc (inside worksheet: VesselDetail) to be reflected accordingly in worksheet: ServiceReport

Is this possible?

Thanks for the response Roy!

[Spiritseye]

Is there no other way to work around this?

[royUK]

As I said yesterday, post a workbook. Can't work with images

[Spiritseye]

Dear all,

As attached is a test worksheet.

After choosing a vessel name in the combobox in "sheet1". The appropriate data located in the "vessel" worksheet, related to the name (eg. callsign, equipment type, ISN, IMN) will then be also be transfered over to "Vessel & equipment details" in "ServiceReport" worksheet after user click the "confirm" commandbutton in "sheet1"

How can this be done?

Would appreciate the help.

Thank you!