+ Reply to Thread
Results 1 to 5 of 5

Change width of Textbox dynamically

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    409

    Change width of Textbox dynamically

    Hi..
    below part of my entire code and is working perfectly....
    I will explain in short...
    its a while loop which takes the value from each row and pull the data from IE.
    all is fine...

    I have added a textbox named (PrgTxt) and I colored it blue just to show as progress bar as I don't want to use user form separately to show this progress bar....

    my issue is I am unable to get the width of text box every time when wb1 is activated and taking the value of row.

    It only show final width after all my code executed... but I want it to show the current width when wb1 is activated...

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    09-05-2012
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    409

    Re: Change width of Textbox dynamically

    I deleted textbox and used conditional formatting.. and I replaced below code but
    still same issue, its showing Final % only after all my code executed...

    I put a break point at line
    Please Login or Register  to view this content.
    and when I pressed F8 it shows the % correctly in wb1 everytime until the while completes.

    when I removed break point and ran , same issue...... again...

    Please Login or Register  to view this content.
    Replaced with
    Please Login or Register  to view this content.
    Last edited by naveenmarapaka; 10-23-2014 at 05:13 AM.

  3. #3
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Change width of Textbox dynamically

    Hi Naveen,

    Try to remove this line :

    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  4. #4
    Forum Contributor
    Join Date
    09-05-2012
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    409

    Re: Change width of Textbox dynamically

    You made my day.....

  5. #5
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Change width of Textbox dynamically

    Glad to help , and don't forget to mark this thread as Solved.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamically linking textbox and cell
    By Leeban in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2014, 04:04 PM
  2. textbox to cell: fixed width
    By mabulco in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2013, 05:48 AM
  3. Replies: 2
    Last Post: 04-23-2011, 10:28 AM
  4. Get textbox value from custom/dynamically generated form
    By sonyidicula in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2010, 08:52 AM
  5. UserForm TextBox with fixed Width and dynamic Height
    By Soniya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2006, 04:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1