Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 3
Question Add value of (1) to a selected cell or cells

I'm comfortable with excel and formulas but never used any of the developer features.

Can anyone tell me how I could:
click a button I have created on the sheet that will change the value of highlighted cells to the value (1) and fill the cells with a color?

In my head this is how it would work:
1) highlight a group of cells
2) Click the button
All highlighted cells would now contain the value 1 and be filled yellow.

I can create the button and assign a macro to it. I just have no idea how to write the macro, or if its even possible.

I'm open to other ideas if I am going about this all wrong.
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
when I select one cell, why are 5 more cells selected below Mrnetwurm Excel Discussion (Misc queries) 3 August 19th 09 11:15 PM
Multiple cells or columns are selected instead of selected cell or Mikey Excel Discussion (Misc queries) 1 April 29th 09 09:48 PM
Each cell in selected cells test Steven Excel Programming 4 September 10th 08 06:08 AM
Last non blank cell in selected cells Ron Weaver Excel Worksheet Functions 11 January 29th 07 03:29 AM
Macro to take selected cells times a selected cell Craig Excel Programming 4 October 24th 05 12:54 AM


All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"