Community discussion forum

Inserting text from a cell into VBA code

• • Reply

  4 months ago

  by ymohammad

  Yusuf Mohammad

  London, United Kingdom

  Joined 4 months ago

  I have a macro that amongst other things sorts a number of lists by a month, however instead of rewriting the code for every month i want to be able to enter the month into a cell and have the code pick up that month and sort by it. How can I do this?

  For example, my autofilter is: Selection.CurrentRegion.AutoFilter Field:=4, Criteria1:="Jul09"

  But I want to replace the Jul09 with a link to a cell in which i can enter any date in the form "mmmyy" and have the code filter by that date.

  Thanks!

  Post was edited on 27/07/2009 17:27:17 Report abuse
• • Reply

  4 months ago

  by Uncle

  Uncle

  England, United Kingdom

  Joined 7 years ago

  If your month is in cell F1, you can use code like this:

  Selection.CurrentRegion.AutoFilter Field:=4, Criteria1:=Range("F1").Value

  to select the cell value as the criteria.

  Report abuse
• • Reply

  4 months ago

  by ymohammad

  Yusuf Mohammad

  London, United Kingdom

  Joined 4 months ago

  Excellent, thanks!

  Report abuse