Dear LeoTaxi,
Sorry to trouble you,
In the code given by you on 26th Feb 2018 It works fine. In that file in the ComboBox I had sample source words List "A" To "K" from sheet4.
I tried to replace with real Yarn Names given in sheet4. When I replace the row source in sheet4 Cells("A3" to "A13") with Names from
Sheet4 Cells("C3" To "C13") I get this Error ......Run-time Error '91':.........Object Variable or with Block variable not set......
And when I debug it I get error in yellow color at this line in the code given above
mc = .Find(ComboBox1 & "1").Column
I am not understanding what has gone wrong, when everything is finely working. I just tried to replace Rowsource Alphabet words A to K with
with Text Names of the Yarns.
In Sheet4 the original Rowsource Named "Yarn" in Column A and the replaceable RowSource is given in Coloumn C.
How do I correct it.
I am sorry for troubling you and also lots of thanks for the help you have rendered to me.
Working sheet is (Sheet1)..Purchase Rolls with Userform1
Regards,
Mukhtar56
File attached Yarn (revised)
Bookmarks