2 Questions
Hi guys, is possible to create a commandButton to browse files, like windows
bowser to load txt files on the excel worksheet? the second question is I have sumary worksheet that take the data from another worksheet, both are in the same Excel file, I would like to know if clicking double click over the cell with the total I can open a pop window with the detail information that make the total. I would appreciate any information. Thanks |
2 Questions
I'll answer the second question. I think I'd use a
Worksheet_SelectionChange event for this and put the data you want in a location that you access with the event. "Orlando" wrote: Hi guys, is possible to create a commandButton to browse files, like windows bowser to load txt files on the excel worksheet? the second question is I have sumary worksheet that take the data from another worksheet, both are in the same Excel file, I would like to know if clicking double click over the cell with the total I can open a pop window with the detail information that make the total. I would appreciate any information. Thanks |
2 Questions
Q1
From help Dim lngCount As Long ' Open the file dialog With Application.FileDialog(msoFileDialogOpen) .AllowMultiSelect = True .Show ' Display paths of each file selected For lngCount = 1 To .SelectedItems.Count MsgBox .SelectedItems(lngCount) Next lngCount End With -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Orlando" wrote in message ... Hi guys, is possible to create a commandButton to browse files, like windows bowser to load txt files on the excel worksheet? the second question is I have sumary worksheet that take the data from another worksheet, both are in the same Excel file, I would like to know if clicking double click over the cell with the total I can open a pop window with the detail information that make the total. I would appreciate any information. Thanks |
2 Questions
for a double click as requested, wouldn't it be better to use the BeforeDoubleClick event? http://www.cpearson.com/excel/events.htm for an overview of events if the OP is not familiar. -- Regards, Tom Ogilvy "Barb Reinhardt" wrote: I'll answer the second question. I think I'd use a Worksheet_SelectionChange event for this and put the data you want in a location that you access with the event. "Orlando" wrote: Hi guys, is possible to create a commandButton to browse files, like windows bowser to load txt files on the excel worksheet? the second question is I have sumary worksheet that take the data from another worksheet, both are in the same Excel file, I would like to know if clicking double click over the cell with the total I can open a pop window with the detail information that make the total. I would appreciate any information. Thanks |
All times are GMT +1. The time now is 02:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com