Hi everyone, I'm brand spanking new and am seeking help from sages. Basically I have a dilemma, I want to create a form in which users can:

1. Select a Column (Column H in my case)
2. Enter a value as input that will be matched up with the values in that column
3.With these selected values (integers), replace all of them with the NEW value.

I've been trying to stitch together a frankenstein macro of other programs. Hopefull you guys can help.

Heres my logical flow:
Sub DepartmentChanger

X, NewX; integer

User: Input Value X
PC: Does Value X exist in the system?
IF Value X = TRUE
THEN Input NEW value X,
X = NewX
ELSE "No such value exists".

end.

Thanks.