| Thread | Last Post | Replies |
|
| If then else | 21 Feb 2006 01:50 GMT | 19 |
I have a spreadsheet that tracks time sheet information. I have a cell (A2) that has a drop down list with 2 options- "Tardy" OR "On-Time". I want to be able to make cell A3 mandatory that you fill in how many minutes the person was late if A2 is = "Tardy".
|
| Compare values in different columns | 21 Feb 2006 01:26 GMT | 2 |
Is there a way to compare numbers in different columns and return a different value based on the findings. Given Data: A1 B1 C1
|
| Urgent help needed with modifying VBA in excel | 21 Feb 2006 01:17 GMT | 3 |
I need some help modifying VBA in excel.... i can pay through paypal.... please contact me ASAP at conspiringfate@earthlink.net
|
| How do you make a column number its self in order from a given # | 21 Feb 2006 01:06 GMT | 1 |
|
| How do you make a column number its self in order from a given # | 21 Feb 2006 01:04 GMT | 1 |
How do you make a column number its self in order from a given # infinitly? A1 beginning with 045000 and A2 being 045001...
|
| GetText Client Access AS400 window API Help | 21 Feb 2006 00:36 GMT | 4 |
I am trying to get text from an AS400 session. I have tried many different approaches from SendMessage to GetDlgItemText. I have succeeded in using Edit Copy by customizing the keyboard in AS400 and using API Keyboard events to copy the window to the clipboard and then
|
| Problem coding NextFind | 20 Feb 2006 22:46 GMT | 8 |
This is an attempt to execute a FindNext. The user enters a PO# in a UserForm, and after clicking OK, UserForm13 comes up, with all the data pertaining to that PO. That works fine. I put another button in that form to request to Find the Next Record.
|
| Changing Command Button Based on Data Entry | 20 Feb 2006 22:32 GMT | 1 |
Hello, I am completely new to VBA, so this is confounding me. I have a form to add rows of data to a spreadsheet. I would like to change a Command Button Caption and action based on data entry. Example: user inputs width, length, and height. Command Button caption
|
| Hyperlink | 20 Feb 2006 22:19 GMT | 1 |
I will be making an excel sheet with various hyperlinks to powerpoint or excel files. I want that whenever the link opens up, i.e., a powerpoint or excel document opens up.......there is something on that opened sheet where i can click and the opened document closes and
|
| Copy and Paste Special Dynamic Range | 20 Feb 2006 22:16 GMT | 1 |
I have a varying range say A2:E40 (E40 varies every week), I would like to copy this varing range to the end of another varying range say H2:L40 (L40 varies every week) is this possible???? 1. Assume there might be embedded blanks.
|
| Urgent simple formula help | 20 Feb 2006 22:06 GMT | 3 |
Ok, here is what i'm trying to do. I have 2 colums, b and c. B is a list of days in the month and c is a list of each temp for each day. I need to write a simple formula that will find the highest temp in c
|
| Finding the End of a Range | 20 Feb 2006 22:02 GMT | 9 |
Is it possible using code to find the bottom of a range in say column A tia BigH
|
| 1004 - Unable to set the hidden property of the range class | 20 Feb 2006 21:50 GMT | 3 |
I'm getting the error mentioned in the subject line when I initially click (first open the workbook) on either of the command buttons associated with the code below. Once I manually unprotect the worksheet, the command buttons work correctly. Any help would be appreciated.
|
| Inability to Capture Username | 20 Feb 2006 21:30 GMT | 5 |
I have created an install routine using a Userform that runs code conditional to the Username. However, the procedure is not recognizing the value of the strName variable. ================
|
| Show only specified columns | 20 Feb 2006 21:16 GMT | 2 |
Newbie question: I have a row with mutliple sequences of weekdays (MO TU WE TH FR SA SU MO TU WE TH FR SA SU MO TU WE TH FR SA SU...) all containing different values. What is the easiest way to show only a specified day...for example Wednesdays?
|