| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start macro upon cell's change in value, 5 questions
Thanks for the prompt response. Neal.
"Bob Phillips" wrote: "Neal Zimm" wrote in message ... Am novice in VB, I've programmed in fortran, SAS, cobol etc... Q1) recommendations on Visual Basic books ("geared" to Excel?) Check out http://j-walk.com/ss/books/index.htm and http://www.contextures.com/xlbooks.html Q2) How do I get code to excecute only on worksheets that I want? Worksheets have specific events that you can tap into. You get to a worksheet code module by selecting the worksheet name tab, right-click and select6 View Code from the menu. Q3) it appears from other notes that private sub worksheet_change() my code end sub is the lowest level of event change and will be where I put my code. True? Don't know about lowest level, but it is a worksheet change that can be used to trap a cell change. Q4) how do I show an simple error msg when b2 contains a bad value and prevent further data entry? a blank or null cell is a valid value. (I am familiar with if ... then .... else syntax) Prevent further entry where? In that cell, if so, how do they correct it? You can show an message like so If Range("A1") 10 Then MsgBox "Cell A1 cannot be greater than 10" End If Q5) Don't know if this will be beyond my very near term skill level, but, in a perfect world, for some of the values in b2, I'd like to place what the user enters in d2 inside a 'graphic'. e.g. if b2 = "4" then put 1234 'inside' an oval. the oval and the 1234 inside it would have to fit within the boundaries of the d2 cell. Graphics are not related to cells in that way, so getting a graphic to be within a cell is complex, more complex than it is worth IMO. I would suggest you get a book,. get started, and come back when you have a specific problem.And it will help if you describe the requirements and design as best you can. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change value based on another cell's value | Excel Discussion (Misc queries) | |||
| How to change an other cell's value? | Excel Discussion (Misc queries) | |||
| Change a cell's value using a button | Excel Discussion (Misc queries) | |||
| Can I automatically start a macro if the contents of a particular cell change | Excel Programming | |||
| Start macro on cell change | Excel Programming | |||
Threaded Mode
