• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filling textbox with text dta dynamically

K

kaushik03

Member
Hi All,


Is there any way we can fill a textbox dynamically with certain text data (say name of persons which are stored from A1:A10)?


The number of texts in col A may always change. Sometimes it is A1:A5 or sometimes A1:A15....something like this.As this happens, the textbox length should also be adjusted accordingly.


I am wondering if we can do it without undergoing a userform technique.


Does it make sense?


Looking forward to your advise.


Kaushik
 
Hi, kaushik03!

Tried defining a dynamic named range and applying data validation? Would it be the same?

Regards!


EDIT:


Sorry, I misunderstood: you wrote text box and I read drop down box. Please discard.
 
SirJB7,


Thank you for your quick reply.


Yeah...that could be one way to achieve this.


But considering some kind of a good visual effect, I was wondering if we could show the info in a floating text box (I love this feature:), it is very common feature when we use flash technology)on click of a button and hide it.. kind of..


Any thoughts?


Kaushik
 
Hi, kaushik03!

I think it's the equivalence for the ToolTip property of Visual Basic but not in Excel.

Regards!
 
Hi, kaushik03!

I'm leaving not, tomorrow night I'll come back. For the time being I suggest you to implement the Jordan's technique. 'til tomorrow.

Regards!
 
Hi SirJB7,


I am so happy to know that you are still interested to help me on this.


I am trying to understand Jordan's technique and posted few of my doubts. Please see the thread here. It would be great if you could answer that as well.


http://chandoo.org/forums/topic/pointing-mouse-to-show-other-series-data-in-the-chart


I am 100 years behind you and Jordan but so happy to get all of yours guidance in order to learn more and more....


Thank you for all your help so far...


Regards,

Kaushik
 
You must log in or register to reply here.
Back
Top