| Thread | Last Post | Replies |
|
| Performing Data Transformations | 17 Aug 2007 13:14 GMT | 2 |
On Sheet1 I have the following data: Column A = Phase Column B = Activity Column C = Jan 2007 – Mgmt. Hours
|
| monitor a specified range ( OnChange) | 17 Aug 2007 13:05 GMT | 2 |
is it possible to change/specify the procedure "Worksheet_Change(ByVal Target as Range)" in an worksheet to a specified Range of Data, for example E7:E61 (Worksheet_Change("E7:E61") ? greets
|
| copy cells to end of range in other column | 17 Aug 2007 12:58 GMT | 3 |
I believe this question has been answered previously, but I can't easily locate the answer. I wish to copy cell value "Y2" to cells Y3 downward to the last row where a value exists in column X.
|
| Debug to Output | 17 Aug 2007 12:54 GMT | 1 |
How can I get ... Debug.Print "For 1 -"; TOP; "there are"; tly; "different lists of"; x; "numbers." ... to pint in a sheet named "R1" and in Cells B3:whatever please.
|
| radio buttons | 17 Aug 2007 12:46 GMT | 1 |
I have two radio button on a worksheet that I need to hide based on the value of one of my cells. Right now I hide several rows based on this cell's value but the radio buttons thta are positioned within that range of rows also need ot be hidden. Here is how I'm hiding the rows:
|
| Save on sheet shift | 17 Aug 2007 12:32 GMT | 2 |
I am new to this VBA, but i will try to give it a go. I would like the workbook to be saved when the user shifts away from Sheet1 to be certain that content of Sheet1 is always saved. I suppose that the piece of code should be placed in a VBA module under the
|
| Inserting blanks | 17 Aug 2007 12:26 GMT | 3 |
I'd like to insert a blank row below any row where the conditional-format bottom border in the range is dark blue (code 5). Help appreciated. =dman=
|
| Calculate cell once (on workbook open) | 17 Aug 2007 11:50 GMT | 2 |
I have a formula that results in the date/time (NOW) a user (network name) opens the file. Problem is, any time a change is made this formula is updated with the most current time. Is there any way that I can make this particular cell calculate
|
| path problem | 17 Aug 2007 11:42 GMT | 3 |
I wrote (with mvp help, of course ;- }) a small app that I have now installed on my work computer, which is on a network. The IT guy set a path to drive P for me and that is where all my files and app are located.
|
| How to encrypt excel pki | 17 Aug 2007 11:39 GMT | 1 |
How do I encrypt an excel file to a pki card or smartcard? I'd like to make an excel spreadsheet that only staff with a pki card can open!
 Signature Del
|
| How to run macro for 10 seconds and stop? | 17 Aug 2007 10:06 GMT | 1 |
I have a simple countdown spreadsheet, which uses the following macro to start it Sub Countdown() Do Until Date = "09/30/2007 23:59:59"
|
| Returning Image Details | 17 Aug 2007 08:37 GMT | 1 |
I have a procedure that inserts various images onto a spreadsheet. I want to be able to select an image (by clicking or maybe right clicking or double clicking) and have a procedure to return the name of the image object. For example, if i click on a particular image that was named ...
|
| listbox concatenate | 17 Aug 2007 07:35 GMT | 2 |
I need to figure out the code to concatenate multiple selections from a list box into one cell with a comma as a divider. This is what I have pieced together from a few sources so far. I get an error when running this, so I know it doesn't work. Any help would
|
| Calendar control | 17 Aug 2007 04:09 GMT | 1 |
I have designed a complex Excel spreadsheet app in which I am not the end user that uses heavy vba including a calendar control. It was designed with Excel 2003 and will be used on PCs with Excel 2003 and XP. I demonstrated the app on a PC in which everything worked fine, however ...
|
| excel 2003 | 17 Aug 2007 03:46 GMT | 1 |
have a question about Excel 2003. I am a programmer but have never used Excel for any programming unitl now. (Note the people who setup these spreadsheets, are long gone).
|