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..

Average	Branch	Start Date	End Date
	Abuyog
	Ajug
	Alang-alang
	Alegria
	Alicia
	Allen
	Aloguinsan
	Altavas
	Argao

<tbody>
</tbody>

 

[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 :

Average

Branch

Start Date

End Date

<tbody>
</tbody>

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 :

Average

Branch

Start Date

End Date

<tbody>
</tbody>

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