Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 465
Default Changing chosen numbers globally via popup


Hi

I have a small task to carry out in Excel. I need a macro that will
offer popups requesting the following

a. Choose a column to operate on.

b. Enter a number to be found in that column.

c. Enter a number to update the number chosen in b.

d. Go back to start of macro at popup a , unless cancelled.


So , I might choose column D , all values at 7.30 to be updated to
12.50.


Can someone help with some code , please?


Grateful for any assistance.
Reply
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
Using a popup to affect a column of numbers Colin Hayes Excel Worksheet Functions 4 June 1st 09 08:29 PM
Automating change via popup to a column of numbers Colin Hayes Excel Worksheet Functions 0 May 28th 09 02:59 PM
Find terms that sum to chosen total among a column of numbers? lstutchman Excel Worksheet Functions 2 April 15th 08 08:59 PM
how can I globally change minus numbers to positive ones? james Excel Discussion (Misc queries) 1 March 9th 07 01:05 AM
Macro preparing numbers to be booked (columns to be chosen conditionally) markx Excel Worksheet Functions 0 May 23rd 06 03:11 PM


All times are GMT +1. The time now is 06:51 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"