Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thanx so much to both of you... I used Zeddy's...

    Thanx so much to both of you... I used Zeddy's approach because I really didn't need to display a message about it being deleted. Just that it was gone and as such... recreated the button... FYI..
    ...
  2. Checking for existence of command button

    I know how to programmatically create a command button... size, text and all that... but how do I check for its existence in order to create it? I want to check to see if someone has mistakenly...
  3. Thanks so much for your input... was hoping to...

    Thanks so much for your input... was hoping to avoid vba as the person I am doing this for wants it as simple as possible but will take a look at it.
  4. Non Repeating Output List from Excel Equal to Input list

    I have this list in a column... 20 different values... I want to generate a random output list from the input list and not repeat. I have used =INDEX($D$1:$D$20,RANDBETWEEN(1,20)) in each of the 20...
  5. Replies
    3
    Views
    244

    Thanx so much for the input... that did not solve...

    Thanx so much for the input... that did not solve the problem either... guess I will have to live with it and use google as my work around.
  6. Replies
    3
    Views
    244

    Help Viewer not working

    In 2010 Word & Excel I receive the following message...

    "The Help viewer has encountered an unexpected problem and cannot continue."

    BUT... the help works fine in Powerpoint. I have Reset IE...
  7. Replies
    4
    Views
    255

    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...
  8. Replies
    4
    Views
    255

    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...
  9. 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.
  10. 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...
  11. Replies
    6
    Views
    657

    THAT'S IT!!! Thanks so much.

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

    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...
  13. Replies
    6
    Views
    657

    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)...
  14. Replies
    1
    Views
    383

    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;...
  15. Replies
    2
    Views
    597

    This does the trick. Thanx so much

    This does the trick. Thanx so much
  16. Replies
    2
    Views
    597

    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...
  17. 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...
  18. Replies
    1
    Views
    404

    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...
  19. Replies
    1
    Views
    459

    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...
  20. Replies
    2
    Views
    416

    Re: ChDir (XL2K3 SP1)

    Jan...

    Thanx so much... worked like a dream.

    Dennis
  21. Replies
    2
    Views
    416

    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
    ...
  22. Replies
    1
    Views
    395

    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
    ...
  23. Replies
    3
    Views
    420

    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...
  24. Replies
    2
    Views
    357

    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...
  25. Replies
    3
    Views
    440

    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,...
Results 1 to 25 of 106
Page 1 of 5 1 2 3 4