Results 1 to 4 of 4

ActiveCell.Offset via Dim

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-08-2006
    Posts
    203

    ActiveCell.Offset via Dim

    Im creating a User Form with a long list of text boxes. I would like to make it easier for me to write the code by copying and pasting the ActiveCell.Offset statments and having the textbox number increase by 1 each time. Here is what I have done, but it does not work. If anyone knows the proper way to do this, I would appreciate it.

    The Dim down works, but the nxpt does not


    Dim down As Integer
    Dim nxpt As Integer
    nxpt = 1
    down = 6
        
    ActiveCell.Offset(down, 0) = textboxnxpt.Value
    
    down = down + 1
    nxpt = nxpt + 1
    
    ActiveCell.Offset(down, 0) = textboxnxpt.Value
    
    down = down + 1
    nxpt = nxpt + 1
    Last edited by iturnrocks; 02-11-2007 at 05:35 PM.

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