+ Reply to Thread
Results 1 to 2 of 2

macro assgned to cell/field

  1. #1
    Registered User
    Join Date
    10-16-2013
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    macro assgned to cell/field

    tried finding this here but havne't been able to - I have several spreadsheets where I've created macros to sort them, as they have so many various columns that I might want to sort for different reasons on different columns.

    So, I recorded the sorting macros - that's easy. Saved them to the "Personal.XLSB" rather than in the individual spreadsheets since it's used so very often. But here's the question - how on earth do I define the text in a specific cell/field as the macro? I've read several different ways using VBA and not one has worked. So, any suggestions?

    Here's a screen shot, to the top right are the two fields, as an example, that I might want to sort by. Each one has a separate macro already recorded, and I used to know (a 100 years ago or so) how to assign a macro to a specific cell, but now I can't figure it out.

    Again, Win 7 Pro 64 bit, Excel 2007

    Screenshot:
    excelsort.jpg

    So, very simple, but I can't seem to figure it out!
    ...if I only had a brain....

  2. #2
    Registered User
    Join Date
    10-16-2013
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: macro assgned to cell/field

    And I guess this should be a question to mods/admins - WTF? Why can't you post an image?????? Uh, gee, it's THE INTERNET, I'm a moderator on 8 forums and admin on 2, and we allow photo postings in all, based on size, and they have to meet a requirement or three. So why not????

+ 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. I need help with making a macro relative to a selection field within the macro
    By namer98 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2013, 11:30 AM
  2. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  3. Replies: 3
    Last Post: 03-03-2012, 12:16 PM
  4. Removing a pivot field in the Value Field - Macro - Pivot Charts
    By hattrick_123a in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2011, 08:33 PM
  5. Putting a pivot field in the Value Field - Macro - Pivot Charts
    By hattrick_123a in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2011, 09:02 PM

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