Results 1 to 3 of 3

Thread: 2 questions

  1. #1

    Thread Starter
    Lively Member James Bond 007's Avatar
    Join Date
    May 2000
    Location
    London
    Posts
    116
    I have two questions.

    How to link a textbox in VB to a cell in Excel?

    How to format a textbox in VB like how Excel format a cell. If I format it to have percent sign, it will always have percent signs.

    Thanks...

  2. #2
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    <?>

    Format a textbox to have a %
    Use a label beside the textbox with a caption of %
    or Text1 = % & "whatever you put in it"
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."

    ___ Adolf Jensen

  3. #3

    Thread Starter
    Lively Member James Bond 007's Avatar
    Join Date
    May 2000
    Location
    London
    Posts
    116
    Thanks but is there a method to automatically format like excel's cell?

    I am doing the formatting in the Lostfocus event for now but like to know a better way.
    License to Program

    007

Posting Permissions

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



Click Here to Expand Forum to Full Width