Re: $$Excel-Macros$$ 2 Queirs, plz give tips

Hi Sajid, I hope the following would be helpful for you having Xl to Exe converter: http://cpap.com.br/orlando/XLtoExeMore.asp Best, Bhupendra Chaudhari On 10/21/2010 9:49 AM, SAJID MEMON wrote: Dear Experts, 1. Query: Can I convert any xls file to exe? if ye

Re: $$Excel-Macros$$ 2 Queirs, plz give tips

1 go to http://www.exceltoexe.com/ 2 instanciate a ComboBox (an ActiveX Control) on sheet righ-click > Properties set the property named ListFillRange = Your Range address for example : A2:A1001 On Thu, Oct 21, 2010 at 11:19 AM, SAJID MEMON wrote: > Dear Exper

Re: $$Excel-Macros$$ Help on Graph

Thanks Ajay and Vijaykumar,Shiv kumar Both Option I can not use (Pivot Table and 0 values) Is there any another option any setting Shrinivas On Wed, Oct 20, 2010 at 11:13 PM, P.VIJAYKUMAR wrote: > Dear Srinivas, > > Just keep zeros whereever there are no values. > > > Regards, > Vijaykumar > > O

$$Excel-Macros$$ 2 Queirs, plz give tips

Dear Experts, 1. Query: Can I convert any xls file to exe? if yes plz give me tips. 2. Query: I have some data in a column, i want it shows in a combo box, through VBA how can we do? awaiting your positive responce, your friend sa

$$Excel-Macros$$ Finding student whose marks are improving over three consecutive tests

Hello I have got sample data as follows: Marks in a single subject Student Class Marks Test A X 20 First B XI 25 First C V 12 First A X 25 Second B XI 23 Second C V 12 Second D VII 3

Re: $$Excel-Macros$$ Dynamically assign values to an array using ComboBoxes

attack the sample file regards r -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/g

Re: $$Excel-Macros$$ Dynamically assign values to an array using ComboBoxes

2010/10/20 RemyMaza > That works fantastic. It has some problems with how my form works > though. Let's say for all 7 combo-boxes, the user can only select > values in order. So if I need 4 devices added, I can't pick from the > first two and then jump to combo box 5 and 6 to complete the form

Re: $$Excel-Macros$$ Dynamically assign values to an array using ComboBoxes

Sweet... That makes a lot of sense. I already had the tab order and the values blanked, so now I guess the ticket is to write a function to handle the OnChange event. Thanks for your help! Cheers, Matt On Oct 20, 10:37 am, Paul Schreiner wrote: > First is to set the tab order for each object. >

Re: $$Excel-Macros$$ Help on Graph

Dear Srinivas, Just keep zeros whereever there are no values. Regards, Vijaykumar On Wed, Oct 20, 2010 at 12:17 PM, Shrinivas Shevde wrote: > Dear All, > Can Any one help me on graph ? > Thanks in advance. > -- > Shrini > > -- > > ---

Re: $$Excel-Macros$$ Dynamically assign values to an array using ComboBoxes

First is to set the tab order for each object. That way, it makes it EASIER to do it in order. Next, I'd recommend setting the initial value of each box to either blank or a specific string. then, define a click event for each object that checks to see if the previous objects have been defined. If

$$Excel-Macros$$ An Alternative to 'Microsoft Visual Basic For Applications Extensibility'

I have a problem that could easily be solved using Microsoft Visual Basic For Applications Extensibility, but cannot enable the 'Trust Access to the VB Project Object Model' setting, so must find another solution >From within Workbook A, I want to retrieve a list of forms, modules, functions and s

Re: $$Excel-Macros$$ Dynamically assign values to an array using ComboBoxes

That works fantastic. It has some problems with how my form works though. Let's say for all 7 combo-boxes, the user can only select values in order. So if I need 4 devices added, I can't pick from the first two and then jump to combo box 5 and 6 to complete the form. I need to force the entries

Re: $$Excel-Macros$$ Help on Graph

Solution is in the attachment. I have used Pivot table and used NA for values of blank. Ajay Varshney On Wed, Oct 20, 2010 at 12:17 PM, Shrinivas Shevde wrote: > Dear All, > Can Any one help me on graph ? > Thanks in advance. > -- > Shrini > > -- > > --

Re: $$Excel-Macros$$ Help on Graph

Hai Srini, Please find attached modified. regards, siva On 10/20/10, Shrinivas Shevde wrote: > Dear All, > Can Any one help me on graph ? > Thanks in advance. > -- > Shrini > > -- > -- > Some important links for exc

Re: $$Excel-Macros$$ Help with DoEvents to show progress form, please?

try this soluction: 'in the class moduleuserform2 'showmodale=false Private Sub CommandButton1_Click() Dim d d = Now UserForm1.Show vbModeless 'your code 'for example Do Loop Until Now > (d + TimeValue("00:00:10")) Unload UserForm1 End Sub 'in the class moduleuserform1 Private Sub UserForm_

Re: $$Excel-Macros$$ Dynamically assign values to an array using ComboBoxes

try in a form add some combobox and a button and add this code: Option Explicit Private Sub CommandButton1_Click() Dim v v = not_null_control_list() MsgBox Join(v, ";") End Sub Private Sub UserForm_Initialize() Dim c As MSForms.Control Dim v 'for example add same value to all combobox v = Array(1

$$Excel-Macros$$ Help on Graph

Dear All, Can Any one help me on graph ? Thanks in advance. -- Shrini -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Link