+ Reply to Thread
Results 1 to 4 of 4

VBA to locate an empty cell in specific range and add text

  1. #1
    Registered User
    Join Date
    04-29-2016
    Location
    Gilbert, Az
    MS-Off Ver
    MS 2010
    Posts
    23

    VBA to locate an empty cell in specific range and add text

    Thank you in advance for any assistance

    I have a userform built and have the values being assigned to a cell. I have a command button I labeled "completed" What I'm looking to do is once clicked it will search for the first empty cell in range (B22:B60) and assign a value of "upskill" and also take the value in a cell "C19" and assign that to the same row in the 3rd column. I have posted the code I attempted but its only clearing the content.

    Please Login or Register  to view this content.
    Last edited by Sway2119; 02-02-2017 at 03:35 PM. Reason: poor title

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,764

    Re: Code assistance

    Hello and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    10-13-2012
    Location
    Southern California
    MS-Off Ver
    Excel 2007
    Posts
    401

    Re: VBA to locate an empty cell in specific range and add text

    Try something like this:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    04-29-2016
    Location
    Gilbert, Az
    MS-Off Ver
    MS 2010
    Posts
    23

    Re: VBA to locate an empty cell in specific range and add text

    Thank you Ed -- I was losing my mind trying to figure that out. I appreciate the assist.

+ 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] VBA Code assistance
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2016, 07:52 AM
  2. [SOLVED] VBA Code Assistance
    By kapeller in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-20-2014, 03:52 AM
  3. [SOLVED] Code assistance
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2005, 01:05 PM
  4. [SOLVED] Code assistance
    By Jim May in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2005, 05:19 PM
  5. VBA code assistance.
    By badger55 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2005, 09:32 AM
  6. [SOLVED] Assistance with code Please
    By Greg B... in forum Excel General
    Replies: 8
    Last Post: 03-02-2005, 11:16 PM
  7. [SOLVED] I need assistance getting VBA code to do the following...
    By SD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2005, 12:06 AM

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