Closed Thread
Results 1 to 3 of 3

Help Writing Macros for Office Home and Business 2010

  1. #1
    Registered User
    Join Date
    04-02-2012
    Location
    London
    MS-Off Ver
    Office 2010 Office and Home
    Posts
    2

    Help Writing Macros for Office Home and Business 2010

    I need some help doing the following:
    I have Office Home and Business 2010, this is the version without Access, and I want to create a small macro that is triggered by clicking a floating button that only appears for cells in certain columns that have been predetermined in the macro. I also want to create a second macro that can search the results that the first macro with create, by clicking a button that is at the top of the column where the title of the column would appear, in the first cell of the column.
    The macros have to perform the following functions:
    Display a form that allows a date to be picked and a free text comment to be entered. Either above or below these input fields display previous dates and comments that have been entered for the cell on that line.

    Each line of the work sheet begins with a unique order number and the transaction generated need to be stored in a separate worksheet with one line for each order number, date, cell, comment combination.

    This new work sheet then needs to be searched by another macro, which resides at the top of the column in the active work sheet that can return lines in the active worksheet base on the section criteria in the macro, looking at the date, comment transactions stored in the other work sheet.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Help Writing Macros for Office Home and Business 2010

    Cross posted here: http://www.mrexcel.com/forum/showthread.php?t=625683

    @ivoryresearch: Please read this: http://www.excelguru.ca/content.php?184

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Help Writing Macros for Office Home and Business 2010

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed 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