LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Updating a validation list macro

Hi

I cannot find this in the groups anywhere.

I would like to update a validation list, which is in cells "FR2" to
"FR26" which contains a list of names. I would like a user to be able
to click on a button which pops up with a message saying "Enter New
Buyer Name", they enter the name, click ok and then the validation list
has been updated in alphbetical order with that persons name.

Could someone help me with the coding for this pls.

Thanks in advance.

roger

 
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
Data Validation List Macro Lisa C. Excel Discussion (Misc queries) 18 April 6th 09 12:53 PM
Create auto updating data validation list from all worksheet names fryguy Excel Worksheet Functions 7 December 11th 07 08:59 PM
Updating a Validation List Dmorri254 Excel Programming 3 February 25th 06 12:54 AM
Creating a Validation List Through Macro Pavan Kishore K. S.[_2_] Excel Programming 0 August 11th 04 05:07 AM
Macro for updating memberssubscription list annually Dawn[_3_] Excel Programming 1 June 1st 04 03:17 PM


All times are GMT +1. The time now is 06:36 AM.

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"