GO C IT Solutions

Help for your data journey

GO C IT Solutions

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • Subscribe
  • About this website
  • About AlanP
  • Comments
  • Contact

Tag Archives: Data validation

Validating data using Excel’s built-in functionality or macros

Macro to Select the Date

Posted on 20 Feb, 2015 by AlanP

Are you looking for a macro to select the date? Recently I was looking for some type of calendar or built-in dialog box that would enable a user to select the date which I would then feed into my macro. I saw one option but that looked too involved for my purposes so I wrote my own function. Continue reading →

Posted in 2 Intermediate, Macros and VBA | Tagged Data validation, Macros, Restrict values, VBA functions

Restrict Values in a Cell

Posted on 20 Sep, 2013 by AlanP

You can restrict values in a cell by applying Data Validation.  You can also add a message when they select the cell and another message if they enter data that doesn’t match your criteria. Continue reading →

Posted in 2 Intermediate | Tagged Data validation, Named ranges, Restrict values

Recent Posts

  • Change in Focus
  • Formatting in Excel
  • Macro to Select the Date
  • Trim Your Selected Data
  • Waterfall Chart

Tags

  • Charts
  • Data tables
  • Data validation
  • Emailing
  • Excel functions
  • Filters
  • Formatting
  • Formulas
  • Macros
  • Named ranges
  • Power price comparison
  • Printing
  • Quick Access Toolbar
  • Restrict values
  • VBA functions
GO C IT Logo

© 2017 GO C IT Solutions Ltd                                         Discount Domains