One TextBox Show Column and the other show Cell address Solved by : ragulduy

Please Login or Register  to view this content.

ragulduy

i don't want this

see the below file

Please Login or Register  to view this content.

hello ragulduy

nope ragulduy i think u r not understanding what i want


i add value in textbox1 = d:d , and i add value in textbox2 = 3:4
now
i want the result in textbox3 = d3:d4

using userform

haroon2015

Hi,

You are right, I'm not 100% sure what you want. I think:

Please Login or Register  to view this content.

will give you
"$D$3:$D$4"
so maybe try something like:

Please Login or Register  to view this content.

hello ragulduy

plz add ur code with my file sample


thanx a lot

hello ragulduy

the textbox1 value will be always set like =d:d or h:h,

but

the textbox2 value will change by me , like 3:15, 18:100

now

i want the result in textbox3 like = d3:d15, or h18:h100

Hi, that is what the code I provided does I believe.

hello ragulduy

Please Login or Register  to view this content.

This is working