$$Excel-Macros$$ Data Validation and 2 Dimensional / Table lookup

2017-02-22 Thread 'The Frog' via MS EXCEL AND VBA MACROS
with Index / Small but cant get it to work. Any help would be greatly appreciated. Cheers The Frog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ Data Validation and Unique Array Values

2016-06-09 Thread 'The Frog' via MS EXCEL AND VBA MACROS
Hi Everyone, I have a question relating to data validation formulas: I have two columns that I am using for defining details for products. The first column is called Category. The data validation for this is done from a simple named range called "Category" and is working properly. The second

$$Excel-Macros$$ Can Solver be used to find the optimum answer to this problem?

2016-02-15 Thread 'The Frog' via MS EXCEL AND VBA MACROS
of HDD's for a particular storage device is limited - The largest HDD the device can support is limited If anyone can point me in the right direction this would be wonderful. Regards The Frog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

$$Excel-Macros$$ Re: Excel commands to Electronic user interface.

2014-07-16 Thread The Frog
) that usually have some sort of API that you can use to communicate with the software and issue commands / receive data with it. Do you have an approach you are going to use? If so we can probably figure out a way to get Excel talking to it. Cheers The Frog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

$$Excel-Macros$$ Excel 2013 Userform Popup menu

2014-05-07 Thread The Frog
).OnAction = removeValueGroup .Controls(2).FaceId = 72 End With 3/ In the forms Click event: Application.CommandBars(myMenu).ShowPopup You will get an error on the .ShowPopup method call. I dont know what the cause of this error is. Any help is greatly appreciated. Cheers The Frog

$$Excel-Macros$$ ImageList Control on Userform in Excel 2013

2014-05-02 Thread The Frog
with images / icons at design time via its properties, but this does not seem to be there anymore in Excel 2013. Does anyone know if there is a way to load it with images and keep them there forever / save them into the form? Any help greatly appreciated. Cheers The Frog -- Are you =EXP(E:RT

$$Excel-Macros$$ Re: Forecasting Methods using Excel

2013-08-26 Thread The Frog
keep feeding new data into it and the statistics you are working with with keep adapting to any changes - they are great this way. Take the time and you wont go wrong. Cheers and Good Luck The Frog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW

$$Excel-Macros$$ Re: Microsoft Excel : Even in 2013 bug is yet to fix !!!!

2013-06-13 Thread The Frog
the programming language). You cant use 'History' for a Sheet Name any more than you can use 'IF' as a variable name in VBA. The Frog -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

$$Excel-Macros$$ Re: Access Problem

2011-05-09 Thread The Frog
the SQL cannot be processed by MS Query, and you will see an error similar to what you have described. Are you able to post the SQL that MS Query is generating in its attempt to get external data? I can probably correct it if it is not too complex. Cheers The Frog

$$Excel-Macros$$ Re: Excel Utility for retrieving data from website

2011-04-14 Thread The Frog
captured and stored (ie/ you dont want things that havent changed). How to manage the output is entirely up to you and what you want to achieve. I hope this is of some help to you. Cheers The Frog -- -- Some important

$$Excel-Macros$$ Re: creating forms in excel

2011-01-25 Thread The Frog
a simple piece of retail POS software or a cash register with advanced functions. Please have a think about what you want and come back to us so we might be able to help. Cheers The Frog -- -- Some important links

$$Excel-Macros$$ Re: NEEDHELP

2011-01-21 Thread The Frog
needed here at all. Beyond this you will probably need to know about DAO / ADO for dealing with the database and also be familiar with the Outlook object model and its events. Cheers The Frog -- -- Some important links

$$Excel-Macros$$ Re: UDF as trigger

2011-01-20 Thread The Frog
Can you post your code for the UDF so we can see what you are trying to do. I have had no issue changing multiple cells / worksheets / workbooks from a single UDF. But maybe we are not talking the same thing. Can you share with us what you are doing? The Frog

$$Excel-Macros$$ Parsing a range to an array

2010-10-28 Thread The Frog
each chunk separately adding it to an array, but was wondering if someone already has an approach to solving this? Any thoughts would be appreciated Cheers The Frog -- -- Some important links for excel users: 1

$$Excel-Macros$$ Seemingly simple thing.....

2010-10-15 Thread The Frog
this rather than cell by cell iteration? I need to keep this macro as fast as possible as it can be working with many tens of thousands of cells. The above code captures the range into the array near instantly. Cheers The Frog