Posts by dmilanb

  • Multi link button

    Re: Multi link button


    Hi Roy,


    I get a list of the machines in listbox1 and for every machine I got special folder with pictures and docs for that machine in my dropbox folder... I need a buttton because what I want is :
    1. click on first machine in the listbox (ID1), the button (btnDocs) link should be to files in folder (for example "folderID1") with docs for machineID1,
    2. click on first machine in the listbox (ID2), the button (btnDocs) link should be to files in folder (for example "folderID2") with docs for machineID2,
    3. click on first machine in the listbox (ID3), the button (btnDocs) link should be to files in folder (for example "folderID3") with docs for machineID3............


    when selected on listbox I get data for that machine in textboxes, and I want to have an option just in case I want to see images for that machine.


    so, the objective is to have a button that is dependent of selection on listbox.


    Thank you for trying to help me

  • Multi link button

    Hi All


    I'm trying to solve this: got userform with listbox and one "depending" button when is click to open docs from folder. What I want is: depending on where I click on listbox, button hyperlink to change to different doc.
    Is that possible!??
    in other words

    Code
    Select Case Me.Listbox1
    Case .Selected.Listbox1.ListIndex = 1
btnDocs = ActiveWorkbook.FollowHyperlink Address:="Mac:Users:dmb:Dropbox:Machine:folder1:image1.jpg", NewWindow:=True
 Case .Selected.Listbox1.ListIndex = 2
btnDocs = ActiveWorkbook.FollowHyperlink Address:="Mac:Users:dmb:Dropbox:Machine:folder2:image1.jpg", NewWindow:=True
Case Else


End Select


    Any help will be appreciated
    cheers

  • Date picker, userform and other problems - Excel for mac

    Hi,
    i'm trying to create an phone book from template which I found at http://www.onlinepclearning.co…ntact-manager-excel-2010/
    and i got a list of problems(maybe because i'm using Excel 2011) :
    1. rowsource does not exist (work) on the Mac so I replaced this line

    Code
    ListBox1.RowSource = Sheet1.Range("outdata").Address(external:=True)

    with

    Code
    ListBox1.List = Sheet1.Range("outdata").Value

    not sure if this is ok?!
    2.ListBox1 has no column headers, no idea how to add them!?
    3. How do I add a date picker to TextBox6(Last Call) and TextBox7(Next Call)to enable user to pick the date?
    4. when i filter by date in cboSelect(Select Field) i got no match, how to fix that





    I'm complete noob when it comes to VBA and I’m not very knowledgeable in writing code all i did was more like copy/paste. btw I tried to use DatePicker from http://www.rondebruin.nl/mac/addins/datepicker.htm but I have no idea how to make it work.


    Any help would be appreciated
    Thank you