+ Reply to Thread
Results 1 to 5 of 5

Help endiing my code

  1. #1
    Forum Contributor
    Join Date
    09-05-2008
    Location
    UK
    Posts
    103

    Help endiing my code

    Hi

    Sorry for the vague title, didnt know what terminolgy to use. I have the following code

    Please Login or Register  to view this content.
    It works perfect if I leave out
    Please Login or Register  to view this content.
    New to VBA and been making do with asking questions, finding examples etc. What i need is on button click it do the above then get value from S10 on sheet calc

    Some help be great

  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
    26,949

    Re: Help endiing my code

    Hi,

    Leave out 'Next' and try
    Please Login or Register  to view this content.
    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
    09-05-2008
    Location
    UK
    Posts
    103

    Re: Help endiing my code

    I get object doesnt support this property or method.

    First part of code is inserting values to sheet to perform calculations then the last part of code was to retrieve the finished calculation

  4. #4
    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
    26,949

    Re: Help endiing my code

    Hi,

    Perhaps you'd better upload your workbook so that we're not all guessing what you mean.

  5. #5
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Help endiing my code

    Hi welshman010,

    As per your code in post #1,

    Please Login or Register  to view this content.
    Just check your code, you have period before TextBox7.

    Try this code instead:

    Please Login or Register  to view this content.

    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

+ 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 to save current worksheet as temporary PDF file and then add to my existing code
    By brianfromla in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2014, 08:35 AM
  2. [SOLVED] VBA code for assigning a numeric code to text; then numeric code populates table
    By cteaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2014, 08:01 PM
  3. Replies: 1
    Last Post: 11-13-2013, 10:28 AM
  4. Replies: 2
    Last Post: 03-09-2013, 04:30 AM
  5. Replies: 0
    Last Post: 10-06-2006, 09:05 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