Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 265
Default An image appears when a cell is selected

Im doing something that I thing there are somehow easier and functional
If I make a validation (List Validation) when I get into the cell appears a
little button with a little row pointing down, now, I want when I select a
cell, the same button appears, but with a different image and the macro
should apply an autofilter, I mean:

sub filterF()
ActiveSheet.Range("A1", Range("A65535").End(xlUp)).EntireRow.Select
Selection.Sort Key1:=Range("F2"), Order1:=xlAscending, Header:= _
True, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("a2").Select
End Sub

If this possible
Pd. I know its easier to apply just the autofilter but, I want to know if
this is possible and how to accomplish it

TIA

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple cells or columns are selected instead of selected cell or Mikey Excel Discussion (Misc queries) 1 April 29th 09 09:48 PM
data selected is not what appears on the chart JJ Charts and Charting in Excel 1 September 2nd 08 09:35 PM
Selected Cell in a Range Appears in another Cell Nick'o Excel Worksheet Functions 1 August 25th 07 08:26 AM
Plus sign no longer appears when cell is selected Ashley Excel Discussion (Misc queries) 2 December 14th 06 06:42 AM
Macro to take selected cells times a selected cell Craig Excel Programming 4 October 24th 05 12:54 AM


All times are GMT +1. The time now is 02:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"