Selecting rows/columns in Excel

[pjkl_1]

Hi,

this is a very simpy question (and what bugs me I used to know the answer, but I have forgotten it and can't remember).

I want to create a comboBox in Excel and then display the contents of other cells dependend on what I have chosen in the comboBox.

Basically it would be a case where the cell displaying the result would have something like this:
=Ji
J being the column (constant)
i being depended on the result in the 'cell link' field.

J1 would contain the first information being chosen
J2 the second and so forth

Right now Excel doesn't recognize the 'i' as a variable and complains (how do I tell it that it is one?)

Thanks, PJ

[ltpeter_y]

Hello
Please visit http://xls.i.am/ and leave your question at http://forum.onecenter.com/excel/. This is my thai excel guru teacher. He can help you on Ezcel coding and using function. Hope this information will be useful for you too much.
Bye

[pjkl_1]

Thanks itpeter_y, unfortunately the links lead to Thai pages and I have a hard time reading it.

Are there any other useful help/tutorial pages on Excel?

[Nitro]

I think this what you are looking for.

http://forums.vb-world.net/showthrea...threadid=24435

[ltpeter_y]

Hello
Please click this link http://forum.onecenter.com/excel/ and then click the right button to post the question in english.
My excel guru teacher will reply you in english, don't worried.
Bye

[ltpeter_y]

The excel expert homepage on english version is http://www.geocities.com/i4zr/excel/expert_train.html
If you wolud likt to send email ask him please send to : [email protected] . He can answer your question in english
Hope this information will be useful for you.
Bye

[pjkl_1]

Thanks very much Nitro and itpeter_y,

Ok here is the explanation again,
I wanted to fill a comboBox with Names of Addresses (sort of abbreviations) and then if I click on one, it writes the complete address into a predefined field. The application is a form where multiple addresses are used. I needed the answer to the first question above to do this. Now however I have spent a pretty good time, kept reading around on this board and finally came to a conlusion that works.

Right now I have two sheets in one file. The first sheet (called 'Form')is the actual form with the comboBox. The comboBox contains a link to the abbreviated addresses on the 2nd sheet (called Addresses). When I click on a name it pulls up the corresponding address from that second sheet and places it in a defined location on the form.

So basically I am putting the information into a string that is being placed into the fields on the other sheet. And the answer to my original question would be: Range("A" & 1).Value=...
A and 1 being interchangeable.

Here is the code:

Sub DropDown3_Change()
Dim attn_address As String
Dim street_address As String
Dim city_address As String
Dim state_address As String
Dim zip_address As String
Dim address_select As Integer
Sheets("Addresses").Select
address_select = Range("C" & 1).Value + 1
attn_address = Range("D" & address_select).Value
street_address = Range("E" & address_select).Value
city_address = Range("F" & address_select).Value
state_address = Range("G" & address_select).Value
zip_address = Range("H" & address_select).Value
Sheets("Form").Select
Range("I" & 4).Value = attn_address
Range("I" & 5).Value = street_address
Range("I" & 6).Value = city_address
Range("I" & 7).Value = state_address
Range("I" & 8).Value = zip_address
End Sub

address_select is the value for the 'cell link' variable in the comboBox.

I hope this helps other VB novices. Thank you all again for your help.

-PJ