interface

Hi dear forum. I am sure you are all familiar with the KeyPress and KeyDown events exposed by userform controls. These events not only allow the user to detect any keys being pressed dynamically, but also give the user the opportunity to discard (block) the key if so desired before it actually...

I know we can get IAccessible of an object by first declaring a variable of type IAccessible and set it to the object we want the interface from, but that requires a reference to a TypeLib in VBE menu -> Tools ->References. Wondering if we can do that without reference and with API only. Ideally...

Why do I not see ANY macro's in the left image while I do see macro's in Alt+F11???? This goes for all my workbooks. I have restarted, repaired Office; checked all Trust settings... no clue.

Hi all, MultiColorDragList.xlsm I have been experimentng with the Comctl32 Listbox control in the last few days. The final result looks good BUT there are two major limitations which I should mention upfront beofre getting too excited. 1- ListBoxes can only be added to MODAL UserFoms. 2- No...

Hi experts, I have a long list of data exported into excel from a text file. This file contains output of a command from multiple network elements. Whenever there is a text string 'Welcome to', the below mentioned text should be copied to a new column till the next 'Welcome to' appears. In this...

Is there a way that I can have the Advanced Editor active when I reply to a thread? When I start a thread, like now, I have the Advanced Editor. But when I reply, I get some other editor and I have to click on the Go Advanced button to get it. In my Settings under Miscellaneous Options, I have...

Ok I think this is simple. I created a bubble chart with info below. How do i get column A to be my legend? <tbody> <colgroup><col><col><col><col><col></colgroup><tbody> Risk Probablity - 1 (low) to 5 (high) Impact - 1 (low) to 5 (high) Traffic Light Risk management strategy Lack of...

I use Atom as my primary code editor/viewer for all of my scripting and html coding needs. I really enjoy the interface and several of the features in offers. Is it possible to use it as a VB editor for excel?

Hi Excel Gurus, below is sample data i have on column A on sheet1, on sheet2 i have headings based on interfaces from below, if there is a match then copy ip address and ipv6 address line to matched column on sheet2. this needs to be looped until the end when blank cell. There might be...

Hi, this is my first post and totally new to excel, I have conditional formatted data it looks for any data which has these words (interface TenGigabitEthernet), (ip address) and (interface Bundle) and highlights it in Yellow, i want to move only this data to another sheet. example below. there...

I'm in the process of developing a solution using Power Query and/or VBA. For the purpose of taking any set of data (from a List Object) and converting this for interface into a financial ledger (automated journal creation). This will involve using userforms and list/comboboxes to: Map the...

Hi, When trying to load a table into the Data Model using Excel 2013 I get the following error message: "Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.WorkbookClass' to interface type 'Microsoft.Office.Interop.Excel._Workbook'. This operation failed because the...

Hi everyone, I just installed Excel 2016 and am trying to create some measures in the power pivot, but this message always appears when I try to write something. Can someone tell me how to solve this? '_______________________________________________ See the end of this message for details on...

Is there a function or a way in excel where you can show the email address in an excel cell of the person who is the default sender/ "FROM" in outlook? For example, if I send an email using my outlook at work, my email address shows as the default email in the "from" section in outlook. I'd...

Hi all, Recent Office security updates has broken ActiveX controls on worksheets .. The usual and rather long-winded fix (Which may not always work) is to locate all exd files and delete them or install the following updates. Here, I took a different approach. I added the ActiveX controls (In...

I am looking for a working formula to calculate the number of days a shop is open. Opening days are usually Wed til Sat, but shop could be open any day, according to business needs. Formula need to be embedded in a excel workbook, which is collecting information's through interface. Workbook has...

I would greatly appreciate any recommendations for a tool/software that can be used to create a sophisticated user interface to a complex Excel worksheet. Unfortunately, I do not believe that a Visual Basic interface would be of acceptable quality (look and feel) to the client for whom I need to...

I would greatly appreciate any recommendations for a tool/software that can be used to create a sophisticated user interface to a complex Excel worksheet. Unfortunately, I do not believe that a Visual Basic interface would be of acceptable quality (look and feel) to the client for whom I need to...

Hoping for some guidance and tried looking at dummies VBA but not managing to get right I have a workbook called interface there are various options say 1 -25 and if the user clicks on say Dundee Information which may be option 9, it opens up dundee informaion I then have a home icon on this...

I have code below to save my workbook file as WriteResPassword, but is there any way to get current workbook's path in the interface from Application.GetSaveAsFilename? For now saving as interface displays document folder, so it requires 5-10 more clicks to get where I wanted. Sub...