Search:

Type: Posts; User: dlkorinek; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    115

    That was not checked BUT... in planning for the...

    That was not checked BUT... in planning for the future, I had placed "Option Explicit" in the code. Once I commented that out all seems to work just fine. Thanx SO much for pointing me in the right...
  2. Replies
    4
    Views
    115

    dialogstyle not working

    What worked just fine in 2003 is now causing a problem in 2010. The code reads...

    dialogstyle = vbQuestion + vbYesNo + vbDefaultButton2

    Now gives me the error message of...

    "Compile...
  3. Thanx so much but this is not an option... IT...

    Thanx so much but this is not an option... IT dept won't allow permissions to do that. I did find a possible workaround over at Ozgrid that I will try.
  4. Add In MS Date Time Picker missing for XL 2010

    My IT dept decided NOT to install the add-in for the MS Date Time Picker control. I have a program that I wrote that allows users to choose a date on a calendar... is there any kind of work around...
  5. Replies
    6
    Views
    311

    THAT'S IT!!! Thanks so much.

    THAT'S IT!!! Thanks so much.
  6. Replies
    6
    Views
    311

    OK... will upload a file called 0test0. If you...

    OK... will upload a file called 0test0. If you look on the tab called "Data" at cell D18 you will see that the cell if formatted to display 5 digits... the actual value in the cell is 0 (zero). If...
  7. Replies
    6
    Views
    311

    Formula NOT displaying 0 (zero)

    On one tab I have a cell that has the value 0 (zero) in it and formatted to display as five zeros (00000). Another sheet has a formula that looks at that cell and returns either a null (blank)...
  8. Replies
    1
    Views
    250

    append Win 7 environment

    My current environment is as such..
    TEMP = c:\temp
    TMP = c:\tmp

    There are progs that will not function with that environ...

    Can I append it to read something like...

    TEMP = c:\temp;...
  9. Replies
    2
    Views
    511

    This does the trick. Thanx so much

    This does the trick. Thanx so much
  10. Replies
    2
    Views
    511

    I want to count whether every other cell has an...

    I want to count whether every other cell has an entry or not. I can do this...

    COUNTA(C4,E4,G4,I4)

    But that gets rather long when dealing with 25 columns. I tried this... but am not getting...
  11. Off 2007 beta destroys Off 2K (Office 2007)

    I downloaded and installed Office 2007. It destroyed my Office Pro 2k. Now when I try to reload my Off 2k it refuses to install. When I try to un-install Off 2k I get the error message

    "This patch...
  12. Replies
    1
    Views
    338

    Lost printer (XP SP2 Home)

    For whatever reason, XP keeps losing my HP Photosmaret 7550. I can go for hours and nothing happens, but then all of a sudden, the printer is gone. The only way to get the printer back is to cycle...
  13. Replies
    1
    Views
    380

    Word crashes (Word 2K3 SP1)

    I was in the process of developing a form in Word... some of the fields got corrupted. Don't know what or why. Now, when I open that particular form, it crashes word. I would hate to have to start...
  14. Replies
    2
    Views
    337

    Re: ChDir (XL2K3 SP1)

    Jan...

    Thanx so much... worked like a dream.

    Dennis
  15. Replies
    2
    Views
    337

    ChDir (XL2K3 SP1)

    I am trying to get Excel to save the file to a certain path / folder / directory but I cannot get Excel to Change Directory. Here is the code..

    Sub Filename01()
    Sheets("Filenaming").Select
    ...
  16. Replies
    1
    Views
    324

    Breaking out of a Loop (XL2K3 SP1)

    I have written this deliberate loop. It is a countdown timer. I am looking for a way to break out of it preferably by a user pressing a button. The code...

    Sub StartTimer()
    Do
    Calculate
    ...
  17. Replies
    3
    Views
    339

    Quitting XL (XL2K3 SP1)

    I am trying to get Exel to quit but it is failing to do so. Here is my code.

    Private Sub ErrMsgQuit()
    Sheets(1).Activate
    msg = "You have failed three times to make and entry in this...
  18. Replies
    2
    Views
    293

    Checking for Subtotals (XL2k SP3)

    I have written some code that removes a bunch of data, then sorts it, and the adds subtotals (from the menu; Data | Subtotals). In order to keep someone from running the code all over again; I want...
  19. Replies
    3
    Views
    383

    Counting Function (XL2K SP3)

    I want to use a function to count items in one column based on values in another. For example... here is some sample data...

    Solution Manning, Jean
    Implementation Manning,...
  20. Replies
    20
    Views
    1,149

    Re: 4th Condition (XL2K SP3)

    Legare...

    Thanx so much for your input. However... the code DOES work. It forces any lower case entry to capitals throughout the range. Maybe it shouldn't work...but it does. If a person makes...
  21. Replies
    20
    Views
    1,149

    Re: 4th Condition (XL2K SP3)

    Hans & Legare...

    Thanx so much for your input. Worked like a champ. Here is the actual code I ended up using.

    Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As...
  22. Replies
    20
    Views
    1,149

    4th Condition (XL2K SP3)

    I have used all of my 3 conditional formatting options but need to add a 4th (maybe a 5th). So I thought I would put something in the ThisWorkbook page so that it would check a range (H8:BI12) to...
  23. Replies
    2
    Views
    350

    Understanding an IF (XL2K SR1)

    I am a little slow in my old age... I received a workbook that has a formula in one of the cells that bascially says..
    IF(ISNA(E9),FALSE, TRUE)
    Is the formula really saying that look at the value...
  24. Replies
    3
    Views
    403

    Re: #N/A (XL2K SR-1)

    Worked like a charm!! Thanx so much.

    Dennis

    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20>
  25. Replies
    3
    Views
    403

    #N/A (XL2K SR-1)

    I have a formula (=IF(ISNA(AC156),NA(),$AF$164)) in a cell that can return the #N/A error, which is fine. I want to programmatically check to see if that is what is in the cell. Activecell.Value...
Results 1 to 25 of 100
Page 1 of 4 1 2 3 4