Results 1 to 16 of 16

VBA Code is not Entering UserForm Values on Worksheet

Threaded View

drsadistic VBA Code is not Entering... 08-06-2014, 11:08 AM
nathansav Re: VBA Code not working 08-06-2014, 11:08 AM
drsadistic Re: VBA Code not working 08-06-2014, 11:27 AM
drsadistic Re: VBA Code not working 08-06-2014, 12:40 PM
FDibbins Re: VBA Code not working 08-06-2014, 11:13 AM
drsadistic Re: VBA Code not working 08-06-2014, 11:28 AM
nathansav Re: VBA Code is not Entering... 08-07-2014, 03:53 AM
Norie Re: VBA Code is not Entering... 08-07-2014, 04:42 AM
drsadistic Re: VBA Code is not Entering... 08-07-2014, 08:03 AM
satputenandkumar0 Re: VBA Code is not Entering... 08-07-2014, 08:10 AM
drsadistic Re: VBA Code is not Entering... 08-07-2014, 08:14 AM
satputenandkumar0 Re: VBA Code is not Entering... 08-07-2014, 08:33 AM
drsadistic Re: VBA Code is not Entering... 08-07-2014, 08:36 AM
nathansav Re: VBA Code is not Entering... 08-07-2014, 08:38 AM
drsadistic Re: VBA Code is not Entering... 08-07-2014, 08:39 AM
drsadistic Re: VBA Code is not Entering... 08-07-2014, 01:22 PM
  1. #1
    Registered User
    Join Date
    06-15-2014
    Location
    Cuthbert, Ga
    MS-Off Ver
    Office 2013
    Posts
    64

    VBA Code is not Entering UserForm Values on Worksheet

    So here is the skinny... I've created a userform to enter data into my sheets. The code should look for the last open cell in the given range and add the data to it. The only thing is, its not working. No errors now, its just not entering the data.

    Private Sub btnOkay_Click()
    Dim LastRow As Long
    
    'Adds 1 to get to the Row following the last populated Row
    LastRow = Worksheets("2014").Cells(Rows.Count, 1).End(xlUp).Offset(1)
    Worksheets("2014").Range("D1" & LastRow).Value = tbNetSales.Value
    Worksheets("2014").Range("G1" & LastRow).Value = tbDiscounts.Value
    Worksheets("2014").Range("p1" & LastRow).Value = tbCreditCards.Value
    
    End Sub
    Any suggestions?
    Last edited by drsadistic; 08-07-2014 at 01:22 PM.

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 working in workbook module but not working from personal.xlb
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-19-2014, 05:47 AM
  2. Replies: 1
    Last Post: 11-13-2013, 10:28 AM
  3. Removing code line stops code working?!?!?
    By adamj1910 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2012, 02:36 PM
  4. [SOLVED] VBA Code (colums to row, autofill) stop working in row 294 when new cable code appear
    By sknifseht in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2012, 05:27 AM
  5. Code for email alerts from excel isn't working, wrong code possibly?
    By jessthorogood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 01:45 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