ComboList produces errors run-time error...

Hello,

Today I am trying to make a userform that uses a combo box, when you pick an item in the combo box I want to be able to click a Cmdbutton and have the selected item put into the active cell of a work sheet. I need it to be able to post to the active cell because there is no way of knowing which thing goes into what cell until you're doing it.

Blah Blah Test ID
Procedure Name&Desc 1 -------------------- Price
Procedure Name&Desc 2 -------------------- Price
Procedure Name&Desc 3 -------------------- Price

That would be a very basic way of how the end result will hopefully look once it is pasted with the Procedure Name, Description and Price done from the user form so the only input is the Test ID (which I could even go on to add a text box to the user form later for that).

However, I haven't even been able to get off the ground because I get a run time error already. "Run Time error 1004 Method 'Range' of object '_worksheet' failed". I have searched the web and it's mostly people just giving out code instead of actually explaining what the person did in the code that wasn't correct or why (no learning value to that if you don't know what you did)

Please Login or Register  to view this content.

I presume that I messed something up with the variables based on what the error says so I went and checked and my worksheet that the information is on is named Services. The range for the items name is named cItm,Description is named cDesc,and price is named cPrice. My combobox is named CmdItem. So I am kind of lost and really bad at VBA code /facepalm I will learn this one way or another.



Thank you for your time!

First, whenever you need help with an error message, tell us which line of code causes the error. It will give a choice of End or Debug. Choose Debug to see what line of code caused the error. In this case it's obvious to me, but that's general advice.

Second, it looks like you are trying to populate a combobox with values from a range of cells in sheet "Services". Most of your code looks OK to me. But what are you trying to refer to when you say

Please Login or Register  to view this content.

?

That syntax means that you are referring to a named range, and the name is "Services". Do you have such a named range in your worksheet? If not, what cells are you trying to refer to? You also have a worksheet named "Services" so maybe you are confusing how to refer to a range with how to refer to a worksheet. Normally this code would look something like this:

Please Login or Register  to view this content.

The range for the items name is named cItm,Description is named cDesc,and price is named cPrice

Are these range names? You have a variable named cItm, but no variables for the other two, so it's very difficult to understand what you are trying to tell us in this sentence.