Programming

make message box appear when cell is clicked?
Learning vba as I go, right now I am trying to get a message box to appear on a user form I created for staff. This is what I have so far: Sub showMessage() MsgBox "Press Alt-Enter to insert a new line" End Sub What would the rest of this code be to have the message pop up when merged cell AE8 is selec... 7 Apr 2010 16:54

Check user credentials
Hi I have a database in access mdb file. In Excel I created a userform where user inputs a username and password. What's the best way to check if the given credentials are correct - in VBA of course? Kind regards IgorM ... 8 Apr 2010 15:12

If date more than
Hello there.. I was trying to cut the entire row and paste it to another sheet if date is more than 20 days say date column is 'H' Someone please help me on this.. Thank you.. ... 7 Apr 2010 15:47

cancel a combobox change
Hello. I want to be able to cancel a combobox change. Cancel is not parameter in the change event, and there is not a beforechange event. I have pasted my attempt below. No matter what item is selected in the event for the combobox, it always changes back to whatever the user selected at the conclusion of t... 7 Apr 2010 15:47

SELECT PART OF A TEXT IN A CELL
Hello, I have this macro which extracts only the rows that contains "VT" in a specific column, copy those rows and paste them transposed to a different worksheet. What I want to do now is to select rows using a different column as criteria (the column before that) and the macro should search the rows that co... 7 Apr 2010 13:32

Countif using symbols
I have a worksheet that has a column containing icons, from the new options of conditional formatting, in Excel 2007 (Icon sets) I need to count how many of each icon I have. Can I do this using the function COUNTIF(). I couldn't figure out what should I use as criteria here. Thanks in advance. Regards, E... 7 Apr 2010 12:23

Error can't Find File
Hi, I have a macro that opens a file and pulls any outstanding tasks from the previous day. I have a problem when it is a new month because the previous month's file is called MyFileMarch2010. The macro now looks for MyFileApril2010. How do I capture the error and look for the previous month's file if it... 7 Apr 2010 12:23

Search and replace multiple values
All; Need to do a search and replace on multiple values: 06 - Phase VI would be replaced by O, 08 - Won would be replaced by W, 09 - Lost would be replaced by L, 10 - Cancelled by Gov't would be replaced by C I've looked for formulas, but what I've turned up is multiple values to one value e.g. $ or - to blank... 7 Apr 2010 11:14

Help on Custom Task Pane in Excel 2007 using Managed code...
Hi, Is it possible to build custom task pane using C#? If yes, can someone point me to the correct links/resources for building custom taks pane for Excel 2007 using managed code (C#)? Best Regards, Venkataramana ... 24 Apr 2010 18:21

Saving information to PERSONAL.XLS
I have a macro that asks the user for their name and email address during execution. How can I save this information so that they don't have to reenter it every time they run the macro on a new spreadsheet? There's no point in saving it to the current spreadsheet, as every time they run the macro, it's on a n... 7 Apr 2010 11:14