+ Reply to Thread
Results 1 to 4 of 4

Creating VBA codes to do what formulas do

  1. #1
    Registered User
    Join Date
    11-27-2010
    Location
    daleville, alabama
    MS-Off Ver
    Excel 2007
    Posts
    21

    Creating VBA codes to do what formulas do

    I have attached the workbook I am working with.

    The problems and objectives are located on the first sheet.

    Any assistance is appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Creating VBA codes to do what formulas do

    Why try to replace formulas with VBA? Excel's formulas are generally more efficient than code
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    11-27-2010
    Location
    daleville, alabama
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Creating VBA codes to do what formulas do

    The cells themselves need to be edited at times and by inputing data into these cells, wouldn't the formula be deleted from the cell?

  4. #4
    Registered User
    Join Date
    11-27-2010
    Location
    daleville, alabama
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Creating VBA codes to do what formulas do

    This is a sheet for some older people that aren't necessarily computer literate, so using the vba over formulas would ensure that the sheet would still function properly no matter what the user input or deleted (as far as information within cells).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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