+ Reply to Thread
Results 1 to 7 of 7

UserForm Change Event

Hybrid View

PDBartlett UserForm Change Event 11-10-2014, 11:02 AM
romperstomper Re: UserForm Change Event 11-10-2014, 11:14 AM
PDBartlett Re: UserForm Change Event 11-10-2014, 11:17 AM
mikerickson Re: UserForm Change Event 11-10-2014, 11:54 AM
romperstomper Re: UserForm Change Event 11-10-2014, 11:44 AM
PDBartlett Re: UserForm Change Event 11-10-2014, 12:18 PM
romperstomper Re: UserForm Change Event 11-10-2014, 12:22 PM
  1. #1
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: UserForm Change Event

    Can you post it?

    Never mind - the problem is here:
    Set oHandler.CellLink = Sheets("Personal Tax").Range("C" & x).Offset(x - 2)
    When x is 1 you're trying to refer to cell C0 which doesn't exist. You need to adjust the logic to whatever fits your layout.
    Last edited by romperstomper; 11-10-2014 at 12:28 PM.
    Everyone who confuses correlation and causation ends up dead.

+ 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. Change userform listbox border with change event
    By EuclideanKraken in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2014, 05:34 PM
  2. Can a UserForm have a change event?
    By PDBartlett in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2014, 11:44 AM
  3. cant keep typing in userform textbox after change event
    By jed38 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2014, 09:13 AM
  4. Couple of Userform, Change event queries
    By welshman010 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2014, 08:46 PM
  5. Userform Multipage Event Change
    By sepandb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2008, 01:40 PM

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