ComboBox Reference Issue

[Steve0492]

Hello,

So I have been struggling for quite some time with this issue. I tried a forum search, but could not find this problem.

I have a list of product names in column A under a named range. I have referenced this range in my combobox as such:

Please Login or Register  to view this content.

I want to take the product that the user selects from the combobox and make it the active cell. I do not want any cells to be changed. What coding could I use to do that? Thanks!

[Steve0492]

An added detail: I hope to execute this task when I press an 'OK' CommandButton I have on my userform. Thanks.

[Charles]

Hi,

A quick answer is to do a "Find" on the selected item in the combo box. You would use a click event for the combobox.

[Steve0492]

Yes, that sounds like exactly what I want to do! However, I am unsure of what the exact steps are to do it.

[Charles]

Can you attach a copy of your workbook?

[Steve0492]

Here is the tab I talked about earlier. The goal of this program is to make the process of changing the status of a product from active to terminated user friendly. The products are in column A are shown in the userform combobox. I essentially want the program to look up the selected item. Later, I will have the userform change the date to the right of the product to the date it was terminated.

[Charles]

Hi,

Just looked ar your workbook and you do not have the "Userform" or code for it. Can you correct the attachment so that it has the Userform and code.

[Steve0492]

I am new to VBA and userforms, so I am unsure how to attached the code itself. I do know if you open up VBA within my workbook, the useform is called "KillProduct". If there is something else I can do to help you help me, please let me know. Thanks!

[Charles]

HI,

You can do a Save As for the original workbook and clean the data if its private. Then send it as an attachment.

[Steve0492]

Here is the workbook. The userform is not yet referenced in the workbook, it is only in VBA under the name "KillProduct". Let me know if you need me to clarify anything else.

[Charles]

Hi,

I'll have something for you in a short while.

[Steve0492]

Thanks a lot Charles

[Charles]

Steve0492,

See attached I coded for the combobox.

[Steve0492]

I appreciate your help immensely Charles, the code worked perfectly!

[Steve0492]

Hey Charles, or anyone with more knowledge than me, your code works very well, but I am having one issue. I cannot properly enter a new date or modify an old date using the Userform textbox. I think this has something to do with the formatting of the cells. I have tried changing the formatting with no luck. Does anyone have time to look at this? Thanks.

Steve

[Charles]

Steve0492,


I looked at your workbook and for the userform "Ok" button it does not have any code associate with it. The button I assume is to allow the user to change the Date and then click it. I modified the code for the "Ok" button.

[Steve0492]

Thanks Charles,

Again, the code on your workbook works perfectly. I have double checked that I have it exactly the same on my useform called "KillProduct_MNL", but whenever I try to edit the date within the userform, it does not allow me. Would you mind taking a look? Thanks.

Steve

[Charles]

HI,

The reason you can not change the "Textbox" because you have a code for it. You need to remove the sub "Private Sub KP_TextBox_Change()"
When you do this the code for the "Ok" will now change the selected data.

[Steve0492]

Got it. That makes sense why it seemed to be constantly refreshing as well. Thanks again!

[Charles]

Thanks for letting me know and thanks for the "Reputation".