VBA Path Error
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: VBA Path Error
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Jul 2009
    Posts
    1,672
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    5 Thread(s)

    Default Re: VBA Path Error

    Hi,

    I had a look at this file and clicking on forms 2 or 3 brought up the file path error dialog.
    So I removed all the forms and put them back 1 at a time and saved the file - no error until I got to Form 2.
    Removed Form 2 and compiled the project. A (copy/paste) error was shown on every forms code. 'S' missing for sheets.

    Code:
    Private Sub ListBox211_Click()
    heets("INTERNAL PRICING").Range("D12").Value = ListBox211.Text
    End Sub
    Fixed all errors and imported Form 2 again and fixed the error on that sheet also.

    I put the file here.
    Try it and see if it is fixed properly.


    https://drive.google.com/file/d/1R9T...ew?usp=sharing
    Last edited by daverunt; Jan 8th, 2019 at 06:21 AM.

  2. #12
    New Member
    Join Date
    May 2013
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Path Error

    Joooh you are a legend! Thank you Dave.

    I wish i had skill like you guys. Would make my life so much easier.

  3. #13
    New Member
    Join Date
    May 2013
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Path Error

    It is working perfect! Thanks a lot again

  4. #14
    Board Regular
    Join Date
    Jul 2009
    Posts
    1,672
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    5 Thread(s)

    Default Re: VBA Path Error

    Glad it's sorted.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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