vba code

[Jefferson2512]

I have a userform with this table and I want a VBA code that when i choose 'Abuyog' as a branch for my combobox, it will appear to the rows where abuyog branch placed..

[TABLE="class: outer_border, width: 500, align: center"]
<tbody>[TR]
[TD]Average[/TD]
[TD]Branch[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Abuyog
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ajug[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alang-alang[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alegria[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Alicia[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Allen[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Aloguinsan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Altavas[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Argao[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Logit]

.
Huh ????

 

[Jefferson2512]

.
Huh ????

Hi Logit,

what I mean is, i have a form and that form had a dropdownlist that contains the names of the branches in the table that i was posted above.. what I want is when i choose 'Abuyog' in my dropdownlist as a branch all the data will be posted in the table and it will be posted only in the row where Abuyog placed.

 

[Logit]

.
Ok ... you have written somewhere in your workbook the following information :[TABLE="class: cms_table_outer_border, width: 500, align: center"]
<tbody>[TR]
[TD]Average[/TD]
[TD]Branch[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[/TR]
</tbody>[/TABLE]


Is the "form" you are speaking of a USER FORM ? Or are you using a worksheet and calling it a FORM ?

Where is the information stored that you want displayed ? (Average, Branch, Start Date, End Date)


Understand that you can see what you are working with but volunteers here cannot. The fastest answers can be obtained
by providing a sample workbook (omit any confidential information) and post it on a cloud site like www.dropbox.com or similar.
Then provide the download link here.

On the surface it sounds like you are needing a VLOOKUP procedure but the other details listed above are required to know how
to give you assistance.

 

[Jefferson2512]

.
Ok ... you have written somewhere in your workbook the following information :[TABLE="class: cms_table_outer_border, width: 500, align: center"]
<tbody>[TR]
[TD]Average[/TD]
[TD]Branch[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[/TR]
</tbody>[/TABLE]


Is the "form" you are speaking of a USER FORM ? Or are you using a worksheet and calling it a FORM ?

Where is the information stored that you want displayed ? (Average, Branch, Start Date, End Date)


Understand that you can see what you are working with but volunteers here cannot. The fastest answers can be obtained
by providing a sample workbook (omit any confidential information) and post it on a cloud site like www.dropbox.com or similar.
Then provide the download link here.

On the surface it sounds like you are needing a VLOOKUP procedure but the other details listed above are required to know how
to give you assistance.

I want my information to be placed in the worksheet .. and the form I mean is a userform in VBE .. I want the information from the userform will be posted in the sheet. and that information will depends on my combo box(branch) in userform .
sorry for bad explanation man