Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Textbox value inputting into wrong cell (Excel 2000)

    Hi all,

    This one I have no idea about, I have a textbox on a multipage form, all I want it to do is place that the value of the box into a range, but when I do that it places it into a range and skips up and down the column.....Maybe I've done something wrong, just wanna know if someone can see anything wrong with the department page?

    The Problem is when I reload the form, the information jumps to a different cell, actually it counts up the O column.

    Thanks Darryl

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Textbox value inputting into wrong cell (Excel 2000)

    Which text box are you having problems with?

  3. #3
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Textbox value inputting into wrong cell (Excel 2000)

    Hi Hans,

    I thought it was only the txtele, but as it turns outs the all of the boxes on the right of multidepartments are messed up, it seems to count up the cell when I input it with the command button, txtele, txtsec,textcirc...the value of the box is supposed to go into range("O7"), but it counts up the column with every input.

    Thanks Darryl.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Textbox value inputting into wrong cell (Excel 2000)

    I'm not sure exactly what you are asking. However, looking at your code, I do see the following:

    The initilization code loads the values for txtSEC, txtCIRC, txtEDIT, AND txtELE from different cells in column O than the code in CommandButton1_Click event routine stores the values to:

    Initilize loads txtSEC from cell O8 CommandButton1_Click stores txtSEC in cell O7
    Initilize loads txtCIRC from cell O9 CommandButton1_Click stores txtCIRC in cell O8
    Initilize loads txtEDIT from cell O10 CommandButton1_Click stores txtEDIT in cell O9
    Initilize loads txtELE from cell O7 CommandButton1_Click stores txtELE in cell O10

    Could that be your problem?
    Legare Coleman

  5. #5
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Textbox value inputting into wrong cell (Excel 2000)

    Thanks,

    I messed there

    Darryl.

Posting Permissions

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