Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Search For:

Type: Posts; User: grim sleeper

Page 1 of 2 1 2

Search For: Search took 0.01 seconds.

  1. Re: Automate Input Login & Password

    Looks really interesting,

    What references/controls/library to I need to assign?

    Thanks,* Auto Merged Post;*I plugged this into a spreadsheet.

    There are two columns of info.
    ...
  2. Automate Username & Password Log In To Web Page

    Hey everybody,

    Here's one for ya,

    I'd like to automatically enter the username and password from a spreadsheet.

    Currently, I've got a spreadsheet that has a login id in one cell...
  3. Re: Calculate Total Weekday Hours With Lunch

    Thanks, I will try it out.
  4. Re: Calculate Total Weekday Hours With Lunch

    I have a dropdown that selects days, swings, or mids, with a vlookup in two cells for start/end times.
    Cell D2 contains the Start Time, Cell E2 the End time.


    mids from 11:00 PM - 7:00 am ...
  5. Re: Calculate Total Weekday Hours With Lunch

    This code works like a champ for dayshift.

    How to manipulate it for swings and mids??
  6. Replies
    2
    Views
    8,807

    Re: Select Specific Slide From .pps Show

    I tried your code in several different locations, but would not work with a .pps.

    I was able to use sendkeys to simulate a shift f5 command but that's not really what I was hoping to do.

    Any...
  7. Replies
    2
    Views
    8,807

    Select Specific Slide From .pps Show

    Hello again,

    I am trying to use excel to open a specific slide on a specific .pps show.

    In my sheet, I have the network address of the .pps file in one cell and the number of the slide I want...
  8. Re: Calculate Total Weekday Hours With Lunch

    Sorry for the late reply,

    However daddy's formula worked awesome!


    Thanks a lot
  9. Replies
    3
    Views
    1,422

    Re: Hotspot A Graphic?

    Get to work Joe!

    Stop playing with pictures.

    How's that 2005 program coming?
  10. Calculate Total Weekday Hours With Lunch

    This seems so simple, until I try to figure it out.

    Here's the dilemna, I am trying to figure out how long it takes to complete one block of instruction. For each block, the instructor will...
  11. Replies
    2
    Views
    778

    Re: Install Microsoft Addins Through Vba

    I believe the setup files are on the network. Seems like I'll just have to add the note on how to set-up for excell.

    by the way,

    thanks for all the help you guys have provided - it has...
  12. Replies
    2
    Views
    778

    Install Microsoft Addins Through Vba

    Morning,
    I've got a workbook that I'd like to be able to give a copy to other users. Most users don't use excel often, so many will not have the analysis toolpack installed on their...
  13. Re: Search Column Then Update Alternate Sheet With Offset

    Thanks I'll try that first thing in the morning when I get back to work.

    should I use find c for the first find, and find I don't know "t", for the second?

    thoughts??

    thanks again.
  14. Search Column Then Update Alternate Sheet With Offset

    Good afternoon from jolly old Texas,

    Here's another question for you excel junkies to solve, while I try to understand what y'all are doing.

    I have two worksheets named "MASTER" and "BEDS"....
  15. Re: Single Calendar Control To Multiple Textboxes

    That's weird, yours works fine but in mine no worky.

    On yours, when you double click the textbox, the calendar form is on top and activated, meaning the title color is blue and the other userform...
  16. Re: Single Calendar Control To Multiple Textboxes

    I commented the .show out.

    Still no worky
    When the calendar form is called up it is immediately put behind the first userform.

    not sure what's going on
  17. Re: Single Calendar Control To Multiple Textboxes

    Okay,

    I looked at this again.

    What it seems is happening is the doubleclick on the textbox is firing the calendar form but is not waiting for user input. it passes all the way...
  18. Re: Single Calendar Control To Multiple Textboxes

    Morning,

    I tried Andy's idea, but now when I double click the textbox the calendar form pops up for 1/4 of a second and is gone. I don't see what is triggering the form_calendar to hide??

    ...
  19. Re: Single Calendar Control To Multiple Textboxes

    I found that I could remove the drop-down from the combobox to simulate a textbox, which might be a feasable work-around.

    Also, how do you change the z-order so the calendar is on top of the...
  20. Re: Single Calendar Control To Multiple Textboxes

    figured that, but not working.


    Public cbodate As TextBox

    fails at >>
    Set cbodate...
  21. Re: Single Calendar Control To Multiple Textboxes

    Hmm,

    this works as a combobox but what about a textbox??
  22. Re: Single Calendar Control To Multiple Textboxes

    I tried

    UserForm1.(CAL.textbox1.text).Value = CAL.Calendar1.Value

    and


    UserForm1.[CAL.textbox1.text].Value = CAL.Calendar1.Value

    but excel no likey
  23. Re: Single Calendar Control To Multiple Textboxes

    The problem is, I don't think referencing one userforms textbox with the text from a different forms textbox will work. Not sure how to properly code this.

    Hope that makes sense
  24. Re: Single Calendar Control To Multiple Textboxes

    Okay, I did this a little different, but I got the textbox on the calendar form to display the textbox name from the textbox_doubleclick. Now, how do you code something like....

    ... ...
  25. Single Calendar Control To Multiple Textboxes

    I performed a search, but nothing fit quite right.

    Does anyone have a slick way to have multiple textboxes on a userform updatable by a single calendar control located on it's own userform.
    ...
Results 1 to 25 of 40
Page 1 of 2 1 2
porno