+ Reply to Thread
Results 1 to 2 of 2

Excel VBA to Activate/Select Cell based on "Found" Range

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    Jackson MI
    MS-Off Ver
    Office 2007
    Posts
    18

    Excel VBA to Activate/Select Cell based on "Found" Range

    Okay, About to pack it all up and Chuck it out the window, but I am attempting a userform to aid with updating a workbook. The ONLY problem I have is getting to any of a set of cells. I can Locate the Cells via Code, and have been trying to put the strings in, but I am hitting a brick wall. This code looks at 1 text box (lName Dim Enm) and 1 combobox (EMonth Dim Mhr)

    I set the range for the find for both Criteria, and when the code borks out, the References are correct (intersection of row CR, and Column CC (Where CR and CC DO correspond to the correct row and Column)

    I am working this button so when a person clicks the button, the Number in a third text box is placed on the spreadsheet at this position. (that part is easy-peasy)

    Can Anyone tell me where I slipped a digit?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Excel VBA to Activate/Select Cell based on "Found" Range

    Here:
    Please Login or Register  to view this content.
    Change to:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. [SOLVED] select, activate, "with", etc. VB operations with tabs and which is more effecient
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2016, 04:57 PM
  2. Cells().Select and .Activate don't "move the camera" to that cell - how do I do this?
    By lordterrin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2014, 03:00 PM
  3. Replies: 3
    Last Post: 04-14-2013, 11:53 PM
  4. Select chart data based on last cell with a value >""
    By peet335 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2012, 02:12 AM
  5. gyclone - sample spreadsheet for "find and select a cell to paste a range "
    By gjolson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2012, 10:29 PM
  6. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  7. [SOLVED] Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select
    By Harold Good in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2006, 04:55 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