Smart List

Replacement For Excel Drop Down For Faster Searchable List Validation

The Smart Replacement For Excel Drop-Down Lists
 

 

Searchable Drop Down List - Multiple Columns - Multi-Selection

 

 

Sorted List, Duplicates Removed, Longer Window,

Larger Font, Easy To Read, Faster Selection

Saving You Time And Effort

 

Plus many options, including displaying a photo of list items, opening documents and web pages.​

 

Automatic Replacement For Excel Drop Down

Plus Powerful Options

Just Add A Range Name

Click My View Smart Lists are helping every-day business users of Excel to work faster, more efficiently and increase the capabilities of their spreadsheets. Smart Lists are an automatic replacement for drop-down lists, that are searchable, easy to read, easy to use, fast and many capabilities to save you time.

 

Smart Lists are faster and easier to use in day-to-day operations than drop downs! They also increase spreadsheet capabilities with numerous options. 

 

All Click My View tools are specially designed to help business users of Excel improve efficiency and productivity. They are for people who want to complete their work in minimum time, with minimum effort, ideally for it to be automated or just require a click. Smart Forms work straight away, with little or no time to set up and no technical skills are needed.

 

 

SMART FORMS Subscription 

 

Pack Starts From

$2 per Week!

subscribe-2580606_1920.png

Display Item Photo, Web Page, PDF or Document

Smart Forms Control Menu

Smart List Is An Automatic Replacement For Drop Down Lists

 

The primary objectives of the default Smart List are: fast, accurate selection of items from an easy to read list, that is searchable, longer, sorted and with duplicates hidden. There are also some great options and new features, that significantly extend Excel List validation capabilities.

 

 

Smart List Default View

 

On the right is an example of the Excel drop-down and the default Smart List Form. Both are at 100% zoom, so you can compare sizes and readability. The Smart List has been filtered for items containing the letter N. 

 

Designed for speed of use:

 

  • Searchable - the items are dynamically 
    filtered, as you type, using the search text

  • Flexible Search Text  - a letter, a word or a phrase, or multiple words or phrases 

  • Vertical Scroll Bar for fast scrolling up and down the list

  • Horizontal Scroll Bar to view long descriptions that are too wide to be displayed

  • Use Tab, Enter or Arrow Keys for a fast exit when no change is needed

  • Clear Selection with a click on a button

  • Easy to read - Size 12 font, (2 sizes larger) and twice as many items in the view (16)

  • Consistent text size - does not change size when zooming in out

  • Setup: Nil

  • Default settings, single selection, sort the list, remove duplicates from the list and hide hidden rows from displayed list.

Drop Down vs Smart List @ 100% Zoom

Other keys:

  • Delete  - deletes cell content and exits, remaining in the active cell

  • Escape  – exits, leaving unchanged, remaining in the active cell

Options include:

 

  • Show Hidden Rows - show hidden rows in the list

  • Multiple Selections - enable multiple selections of items 

  • Multiple Column Display - enable display of multiple columns (unlimited columns) e.g. display product code and name

  • CSV Separator - choice of separators for returning Multiple Selections

  • Returned column(s) - multiple choice of which column(s) to return to the cell. e.g.concatenated  list of all columns or a hidden column (e.g. a product code)

  • Add New Item - allow users to add items to the list on-the-fly

  • Display Photo - allow users to open photo, document or web page

  • No sort -  display items as found

  • List Duplicates - display all items

Smart Forms Productivity Tools


   Helping every-day Excel users to work faster, more efficiently and increase spreadsheet capabilities.

 

  • Smart List - automatically replaces Excel drop downs, searchable, multi-column display, multi-selection. With numerous options, which includes viewing photos, documents, web pages and enabling Smart Dependency Lists – with a new approach, that is much faster and easier than traditional methods
     

  • Smart Cell Calendar – no more blindly typing dates – with fast selection of real working days, etc.
     
  • Smart Dependency List – a new, much faster and easier method, than traditional methods
     

  • Smart Text Edit – an automatic window for cell text editing - with basic formatting, real tabs, bullets, etc.
     

  • Smart Menu -  intelligent menu - go to any cell - auto opens workbooks, sheets and runs macros
     

  • Smart Sheets – click to go to any sheet - hide/unhide individual sheets or all sheets with just a click

 

 

This is a short overview of Smart Forms

Fast Navigation To Next Cell:

  • OK button – default Excel cursor movement to select next cell (to go right or to go down)

  • Enter key -  go to next visible row

  • Tab key - go to next visible column

  • Arrow keys – go left, right, up or down to the next visible cell

Smart List Options

Smart List Default Form

Setup: Nil

Smart List Multi Selection

Setup:

  1. Create range name 

  2. Enter range name in Data Validation Source field

Smart List Multi Column Display, Multi Selection

Note: Form Widens With Extra Columns

Setup:

  1. Create a range name with embedded option codes 

  2. Enter range name in Data Validation Source field

Smart List Display Photo, PDF, Document or Web Page

Local Photos and Images are displayed in a special window (see example)

Local PDF's / Office Documents / Files open in relevant application

Web Pages / Web Links are opened in the default browser.

Setup:

  1. Add a column to validation range and enter link to photo

Setup For Smart List Options
Is Easy And Takes Just Moments

 

1. Create a range name with embedded option codes

 

  • Click Formulas > Define Name

  • Enter CMV_x_rangename - where x = option code(s)

  • Set Refers To Field to existing drop-down range

 

 

2. Change Cell Validation Source To: = new range name

 

Example Setup For Multiple Selections

 

Existing Data Validation Range = Product Name cells (G3:G150)

 

1. Create Range Name "=CMV_1_ProductName" constructed as:

 

  • CMV_ = Smart Form options prefix

  • 1 = Multi selection, with comma separated return value

  • _ = Smart Form options suffix

  • "ProductName" - your choice - e.g. cells contents name
     

  • Set Refers To Field: to existing data validation range (G3:G150)

 

2. Set Validation Source Field To: =CMV_1_ProductName

Example Of Advanced Options Setup

Multi Selection, Multi Column, Return Invisible Product ID

 

Existing Data Validation Range = Product Name cells (G3:G150)

 

1. Create Range Name "=CMV_1VY_ProductName" constructed as:

 

  • CMV_ = Smart Form options prefix

  • 1 = Multi selection, with comma separated return value

  • V = Multi column display - infinite (ends with a blank cell)

  • Y = Return Range Column -1 (Product Id is to left of Name)

  • _ = Smart Form options suffix

  • "ProductName" - your choice - e.g. cells contents name
     

  • Set Refers To Field: to existing data validation range (G3:G150)

 

2. Set Validation Source Field To: =CMV_1VY_ProductName

Detailed User Manual And Comprehensive Example Workbook Included

   Overall control of the Smart Forms is through a ribbon menu, entitled CMV

 

  • About: Displays a message box containing information about the software version

  • Start Functions: Starts all functions – checks the licence and awakes the functions.

  • Stop Functions: Stops all functions – puts them to sleep.

  • Backup File: Creates a backup of your workbook with a time-stamped file name.

  • Sheets: Opens the Sheets window for fast navigation to hidden sheets.

  • Menus On - Off: Enables / disables automatic display of menus.

  • Lists On - Off: Enables / disables automatic display of Smart Lists / Dependant Lists.

  • Calendar On - Off: Enables / disables automatic display of cell calendars.

  • Smart Text On - Off: Enables / disables automatic display of text editing windows.

 

Please join our mailing list for news and updates

 

Smart Forms Overview Header Play.png

"Smart Forms save me time!"

Customer Satisfaction Is Important To Us
We believe in the effectiveness and quality of our products and are confident they will save you time and ease your workload.
 
If for any reason you are not satisfied within 30 days, we will happily return your money.
Guaranteed!

 

Smart Forms Pack Inclusions

 

  • Smart Lists – replaces Excel drop downs, searchable, multi-column display, multi-selection. With numerous options, which includes enabling Smart Dependency Lists – which is a new approach, much faster and easier than traditional methods
     

  • Smart Text Editor – for reading & editing text - with basic formatting, real tabs, bullets, etc.
     

  • Smart Cell Calendar – no more blindly typing dates – fast selection of the day, month & year
     

  • Smart Menu -  intelligent menu - click to open workbooks, unhide sheets & cells, run macros
     

  • Smart Sheets – click to go to any sheet, plus click for fast hiding / unhiding of sheets
     

  • Free point release updates, support, User Manual, Examples workbook, Access to all Videos

 

 

Plus a Free AddIn for Cell Magnification!

 

 

 

 

 

 

 

 

SMART FORMS Subscription 

 

Pack Starts From

$2 per Week!

subscribe-2580606_1920.png
Sunshine Solutions Pty Ltd (ABN 30 124 423 552)
34 Balemo St, Minyama, Queensland Australia 4575
Email info@sunshinesolutions.com.au
  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon