How can I populate the combobox from cells in an xl sheet

[upod]

I have successfully used the course booking form as a base for an input form in an accounting workbook that has several pages. (Thanks to Roy and others for the info; the course booking form on http://www.exceltip.com/st/Create_Us...Excel/629.html is the best explained piece I have found on the net)

What I would like to do is use a range of cells to populate the combobox so that a user can make a choice from the account descriptions (from a sheet named Intro, b63:99) and have the form return the account number (Intro, a63:a99) to the relevant cell elsewhere in the workbook. The user would then have meaningful descriptions rather than numbers to choose from.

My coding for the form thus far is as follows.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can anyone guide me on how to do this, please?

I use Excel X for Mac (rowsource is not an option)

[VBA Noob]

upod,

Welcome to the forum.

Your thread has being moved to it's own post and your code has being wrapped. Please follow the forum rules below before posting again

Many thanks

VBA Noob

[upod]

After spending much time looking for solutions, I posted the request for help yesterday. Today I managed to get the code below to work. Guidance notes have been left in;

Please Login or Register  to view this content.

As noted in the code I would like to refer to the cells by a pre-defined name so that the code does not need to be rewritten should the source data cell range change.

Many thanks
upod

[royUK]

In one of my ccount programs I have a ListBox hat displays 3 Columns-Code number, Category, Sub Category. The list of codes is stored in a hidden sheet named AccCodes in a named range called cost codes consisting of 3 Columns of data. The listbox is loaded by one line of code;

Please Login or Register  to view this content.

The entry to the data sheet is made to Columns corresponding for each column of the ListBox

Please Login or Register  to view this content.

[upod]

Thanks RoyUK

Will give it a try ; as mentioned in my original post, rowsource is an issue on the mac platform. My xl help warns that it is not supported on Mac but am not sure if that just means there is nothing in the properties tables. (This demonstrates how little I understand vb)

uPod

[upod]

RoyUK

I tried your suggestion but it gives me a run time error '380'. It seems the rowsource property is the problems as it is this line in the code which is highlighted in the debugger.

If you didn't have rowsource, how would you re-code the line;

Please Login or Register  to view this content.

Note; I changed the sheet/range references for my project.

Thanks
uPod

[royUK]

I didn't see that line, there doesn't seem to be an alternative.

[upod]

Thanks RoyUK

Frustrating as it is at least your suggestions have demonstrated that I shall need to re-write the code when my accounts list area changes.

If anyone has any other suggestions please let me know.

Thanks
uPod

[royUK]

maybe you could load it from a text file (*.txt)

[sawdawg]

This code will fill a combo box named cboProgram with values from a Named Range "Programs" from the worksheet "LookupLists". I usually place it in the UserForm Initialize Module.

Please Login or Register  to view this content.

Not sure if it will work on Mac.

hth

[upod]

With a bit of help from everyone here and some external references that i can no longer find, with a bit of tweaking here and there I have found the following code to work.

Please Login or Register  to view this content.

Thanks to you all