+ Reply to Thread
Results 1 to 2 of 2

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 royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Help Writing Macros for Office Home and Business 2010

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. 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 on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    Hope that helps.

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

    Free DataBaseForm example

+ 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