UserFrom Match, Find and Edit data : ComboBox1 Change range

hello
in my userform according to combobox1.value, find data and edit them

but when i m changing

Please Login or Register  to view this content.

Please Login or Register  to view this content.

D61:D500 has number value

Please Login or Register  to view this content.

You don't need to loop, but you do need to coerce the combobox's string value to a number. Here's the way to do that.

Please Login or Register  to view this content.