Form Log VBA 2013

[owensy]

Need help

Trying to create log using the visual basic function - Is it possible to create a drop down list for example showing the below using the

Private Sub ComboBox1_Change()

End Sub

Mechanical

Electrical

Hydraulic

Other

<tbody>
</tbody>

 

[healey21]

Welcome to the forum give this ago.

Private Sub ComboBox1_Change()

ComboBox1.RowSource = "" 'Clear the list
ComboBox1.Clear 'Clear the selected text

With Me.ComboBox1
.AddItem "Mechanical"
.AddItem "Electrical"
.AddItem "Hydraulic"
.AddItem "Other"

End With

End Sub

 

[owensy]

Cheers,

Still not working it's not referancing the box i have created on the visual basic screen ! any ideas ??

 

[healey21]

Have you created a UserForm in the VBA screen and added a ComboBox as my suggested code would work there but I need to understand a little more of what you are trying to achieve and where you are working with the ComboBox. Is it actually the On Change Event you want or to load the list when the UserForm is activated?

 

[owensy]

Hi,

Yes i have created UserForm in the <acronym title="visual basic for applications">VBA</acronym> screen and added a ComboBox, the fields i want displayed in the box are what i have givin you ! Yes thats correct i'm trying to Change Event to load the list when the UserForm is activated? I'm new to this so please bear with me !!

<tbody>
</tbody>

 

[healey21]

Microsoft Access doesn't allow you to create UserForms within the VBA screen, so I am wondering if you are using Excel rather than Access? Please let me know so I can help further.

 

[owensy]

I am using Execl

 

[healey21]

You posted in the Access forum...

Please show your code that you currently are using