+ Reply to Thread
Results 1 to 11 of 11

Help With userForm and outlook appointments

  1. #1
    Registered User
    Join Date
    03-14-2007
    Posts
    47

    Help With userForm and outlook appointments

    Hi i'm using this code i've put together from various websites i've googled about outlook appointments, My VBA isnt really good, but i have a form ive created where i can book appointments into outlooks calendar
    Please Login or Register  to view this content.
    when im trying this code the .start = me.txtDate.value + Me.txtTime.Value doesnt seem to work, can anyone help?as i need to try and use the .Start line to for date and time.
    cheers

  2. #2
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Help With userForm and outlook appointments

    Can you post a working example file? Can't run the code to help you debug without creating all of those objects, which is time consuming.
    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright

  3. #3
    Registered User
    Join Date
    03-14-2007
    Posts
    47

    Re: Help With userForm and outlook appointments

    there you go
    thanks
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Help With userForm and outlook appointments

    Quote Originally Posted by gmc2k2 View Post
    when im trying this code the .start = me.txtDate.value + Me.txtTime.Value doesnt seem to work, can anyone help?
    Are you addng the txtDate.value and the txtTime.value together? or do you want to have the date and time together as a string?

    ...using the "+" adds the values together mathmatically

    ...if using as a string, take out the "+" and replace it with a "&",

    ....if you need spaces inbetween the date and time, then type it like this:

    .start = me.txtDate.value & " " & me.txtTime.value

  5. #5
    Registered User
    Join Date
    03-14-2007
    Posts
    47

    Re: Help With userForm and outlook appointments

    what i want it do to is for the .start be whatever it needs to be to book an appointment in the outlook calendar for the time and date the user has put in the user form, so would it be & for this to work correctly?

  6. #6
    Registered User
    Join Date
    03-14-2007
    Posts
    47

    Re: Help With userForm and outlook appointments

    when ive tried it either way it keeps on saying mismatch?

  7. #7
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Help With userForm and outlook appointments

    Looks like you are going to have to enter the start date and start time separately, in Outlook they are in seperate fields....problem I have is suggesting the property for the start date...everything I tried didn'y work correctly and gave a mis-match error.

  8. #8
    Registered User
    Join Date
    03-14-2007
    Posts
    47

    Re: Help With userForm and outlook appointments

    Eventually sorted this out, thank you very much for your help, helped me greatly i used this code and had F2 cells =C2+D2

    Please Login or Register  to view this content.

  9. #9
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Help With userForm and outlook appointments

    So it works now?....I was getting an error when stepping through using debug where .Start = something and me.txtDate = something different....same with .Duration.
    ....so there was the error...but I couldn't figure out why they were different.

  10. #10
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Help With userForm and outlook appointments

    Keep it simple:
    Please Login or Register  to view this content.



  11. #11
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Help With userForm and outlook appointments

    Quote Originally Posted by snb View Post
    Keep it simple:
    snb, that works good....thanks for the help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1