Display values in a drop down in range

=?Utf-8?B?bmlyMDIw?=

Guest

Posts: n/a

24th Nov 2006

I have created a macro (see below) that when run selects selects the values
from a range of cells and places those values in drop down list.

Sub DropDown1_Change()
Application.ScreenUpdating = False
rgn$ = Range("b5")
ActiveSheet.Shapes("Drop Down 3").Select ""
Selection.ListFillRange = rgn$

What would like to do is select the values from the drop down list and
display them in range of cells

Please can someone help

thanks

Nick

« Formula problem once inserted by VBA | Advice rather than an actual question. »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to return a range of values in a drop-down.	Joe	Microsoft Excel Worksheet Functions	7	9th Jan 2010 06:32 PM
Drop Down Box to Display range	VanessaY	Microsoft Excel Programming	3	18th Jun 2009 04:48 PM
display range of values	willemeulen	Microsoft Excel Misc	0	4th May 2009 12:15 PM
How to display values from the range	tzmy79@gmail.com	Microsoft Access Queries	2	25th Jan 2007 06:23 PM
Display values set in a range??	rpp114	Microsoft Excel Worksheet Functions	1	4th May 2006 08:08 PM