VBA Code for Userform to change the Enter Key Behavior to false for a particular listbox or a text box

[vish621979]

Hi,

I am very new to VBA programming. I am designing a Userform which adds and edits value to Excel Database. The process has three stages. 1 Collect 2 Analyze and 3 Quality check.

I have put three buttons for each stage. What I want to do now is, when a user clicks on "Collect" button, some of the unwanted listboxes change the enterkeybehaviour to False automatically. So taht the user can not enter any value from a particular list box or a combobox.

Can somebody help me with this please?

thanks
V

 

[mikerickson]

It sounds like you want to change the .Enabled property of the list box rather than its .EnterKeyBehaviour.

Which controls would you want to disable?

 

[vish621979]

Yeah that's correct