Specify a string within a replace function

Hi all,

How can I specify the string "StoreType" within my find/replace code? I want to have Excel take the selected name from the specified range and put in in my replace code. Currently it only inserts "StoreType" instead of the value (name) in Range("Selected_StoreType")... Am I defining my variable wrong?

Please Login or Register  to view this content.

Thanks!! It does what I asked for, but it does not 100% solve the problem (yet). Now it inputs the selected store type from the cell, e.g LARGE(IF((Region=FSS) though, the formula only works with quotation marks LARGE(IF((Region="FSS") Unfortunately when I put "" before and after the string, it doesn't seem to work...?

Also, is there a way to get the store type directly from the list.index from the form control? something like the below?

Please Login or Register  to view this content.

That works smoothly!! Thanks!

Do you also happen to know how to get the value/name directly from the form control list.Index, rather than from a cell?

Please Login or Register  to view this content.

Something like the above?