+ Reply to Thread
Results 1 to 4 of 4

Variable declared as long out as text

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Variable declared as long out as text

    Hi.
    I'm having a little problem and I'm not finding the solution. I declared a variable 'lCodigo' how long, but when added to the spreadsheet, it is becoming as text. I do not understand why. If someone can take a look at the code I'm grateful. I left it in bold with co caretinha to facilitate finding them.

    Please Login or Register  to view this content.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Variable declared as long out as text

    Hi,
    I assume the code is placed behind an userform. what type of control is cmdsequencialancamento? A textbox control? I think that default property of a textbox is text even if the help says that it's value. use

    Please Login or Register  to view this content.
    I think it will do the job.
    Last edited by buran; 02-05-2013 at 08:50 AM. Reason: correct the statement for default property of a textbox
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Variable declared as long out as text

    Hi.
    was perfect!

    thank you very much!!

  4. #4
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Variable declared as long out as text

    I'm glad that it helped. cheers :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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