Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 2 problems -
First, I am using a list box and have "multi-select extended" enabled. When I click in the box, I want to enable a button if an item is selected, disable if no items are selected. Problem is, with multi select enabled, my box won't detect the click. With simple select, this works, but I want multi. Am i missing something obvious? Problem 2 : I am running a vba macro from another application, which it appears doesn't have a File open Dialog box. I thought I could use the Excel GetOpenFileName Dialog (code follows) This works, but obviously I'm doing something wrong here, because I get a "Server Busy - Switch Apps or Retry" Dialog right after the GetOpenFileName closes (gives me the filename, but this dialog warning is annoying) Could someone tell me what I'm doing wrong here, too? Private Sub btnBrowse_Click() On Error GoTo Err_btnBrowse_Click Dim fl As File Dim eApp As New Excel.Application 'Get the path to a file with the file open dialog box Set fl = fso.GetFile(eApp.GetOpenFilename) eApp.Quit Set eApp = Nothing txtDirectory.Value = fl.ParentFolder Err_btnBrowse_Click: 'Do Nothing End Sub Thanks in Advance... -- / Sean the Mc / "I have not failed. I've just found 10,000 ways that won't work." - Thomas Alva Edison (1847-1931) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiselect Listbox use | Excel Discussion (Misc queries) | |||
Multiselect listbox selection question | Excel Programming | |||
MultiSelect ListBox in Excel | Excel Programming | |||
Excel VBA-Looping though MultiSelect on ListBox | Excel Programming | |||
multiselect listbox | Excel Programming |