i want to select all cells with one inputbox

hello
i m using below code to edit data one by one using inputbox
e.g
i have data in c10:c20 and i play code then there is popup inputbox 10 time to edit every cells data one by one
or
i have data in c10:c30 then popup inputbox 20 time to edit every cells data one by one

i want click only one time the inputbox and edit cells one by one (don't popup inputbox 10 times or 20 times)

thanx

Please Login or Register  to view this content.

Hello 2*S
e.g
i have data in c10:c14...
AHSAAN G
ALI G
AYAZ
SABIYA
AJAJ
now i play code, then
inputbox pop up with c10 = AHSAAN = I click ok then
inputbox pop up again with c11 = ALI G = I Click ok then
inputbox pop up again with c12 = AYAZ = I Click ok then
inputbox pop up again with c13 = SABIYA = I Click ok then
inputbox pop up again with c14 = AJAJ = I Click ok then

NOW I WANT THIS PROCESS WITH ONE CLICK AND EDIT ALL CELLS ONE BY ONE

Hello 2*S
whats ur code does?
because nothing is happening

hehehe

but problem is
code is not working as i want

2*S
same thing working my code

ok now u do i click only one time on inputbox then otherbox by default take yes

ok 2*S
if this is not possible to work without hitting Ok button then plz

inputbox select only without duplicates, i mean
e.g
i have data in c10:c14...
AHSAAN G
ALI G
AHSAAN G
SABIYA
AHSAAN G
now i play code, then inputbox popup for onle first cell C10, then C11, then C13(skip the duplicates c12,c14
inputbox pop up with c10 = AHSAAN = I click ok then
inputbox pop up again with c11 = ALI G = I Click ok then
inputbox pop up again with c13 = SABIYA = I Click ok then

thanx