Search results for query: *

Hello, This is probably a nice simple question for most people who have experience with excel/vba.. how can i add a minimize button to a user form? i looked at all the properties and didn't find anything appropriate.. thanks!

hello, i was wondering if vba has any data structures built in that you can use? in particular, a priority queue would be great for me right now.. i don't want to actually implement one.. but if one exists, it would be just perfect! thanks!

hello, i am having a little trouble with some graphing.. in a previous post, i had posted this code to create a graph using arrays: Sub graph(ByRef xvals() As Double, ByRef yvals() As Double, gsoffset As Double) Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers...

hello, i am having trouble selecting cells in a loop. i tried the following code: Do While (i < 10) 'Range(ActiveCell.Offset(i, 0)).Select Cells(i, 1).Select i = i + 1 Loop (also tried teh commented line) this is just some garbage code to see if this was the...

hello, was wondering if there is an easy way to do what i want to do.. i have a form. i have 2 SETS of comboboxes. what imean by this is going to be clear in a second.. when i choose a value from a combobox (non-editable), i would like one of four other combo boxes to be disabled. (So, i have...

hello, i want to use a combo box. i have added teh control.. but what i want to do is to remove the cursor, so the user cannot type anything. they should only be able to select something from the dropdown list. no typing! anyone know how i can do this? thanks!

hi, i was just wondering.. is there something like msdn for vba? i mean.. somethign that just lists what all the properties of different controls mean? i haven't been able to find anything like that.. if i could, i would have to bother you guys less! thanks!

hello, i would like to list the available sheets in a list box. how can i do this? also, i would like to give the user the option to create a new sheet from a form.. any ideas? thanks!

hello.. i have the following function: Function w(ByVal diameter As Long) As Long w = (diameter / 2 * 10 * 2.54) * (diameter / 2 * 10 * 2.54) * 3.14 End Function when i call this function with an argument 12 it returns 72929 instead of 72928.8864. ie it is rounding up for some reason...

hi, if you remember me from yesterday, you know i don't have much experience with vba and i'm a c++ person.. i remember doing somethign strange in vba a few years ago.. something that i know you can't do in c++. i somehow managed to use a string that started with a letter of the alphabet and...

hi, i'm used to c++! sorry.. i have a very basic question. in c++, you can dynamically allocate arrays. ie: int a; a=some calculation, say a has 100 char * a= new char [a] //this is very very legal and done all the time in vba, however, i'm having some trouble: Sub test() Dim numwc As...

hello i have yet another question! i am quite a vb newb! i get some user input from a form. now if i have, say a module, where i implement what to do with the data, how can i pass the data from the "form code module" to the other module? i guess one way would be to use global vars in the other...

hello, i have a form in excel with some text boxes. is there a good way to make sure that the value entered in a text box is an integer? sorry, not very familiar with vba! i do not want a dropdown list or anything.. i want the user to be able to enter any integer. thanks.

hi dont' have much excel experience.. but have been asked to make a small "application".. question: is there a maximum number of cells that you can have in excel safely? in other words, say i want to have 50,000 cells with values (numbers, probably doubles or longs or something), plus whatever...

so, my next question is a very fundamental question, and when i google it, i get weird results making me think that it might not be possible.. but that also seems strange! how can you return a value from a function? so far, since i couldn't find the syntax to do it, i have been passing...

Hi, I am not very good with vb, am a c++ person. In excel, when you write vba macros, is there any special significance for the "This workbook" sheet? from teh name, i assumed that it is a good place to put functions that you need in many sheets... i had a function (which works fine) copied and...

i thought a new post would be appropriate. i am trying to graph something.. (in my earlier post i said that i do not want to display the coordinates for the chart on the spreadsheet, but I CHANGED MY MIND!). so.. now i have coordinates on the spreadsheet. i recorded a macro to draw the graph...

hello, i'm really a c++ person.. but i have to do something quickly in excel and vba.. i was wondering.. can i draw excel graphs from vba and if you know of any tutorials where i can quickly read up on how its done (i'm not completely new to vba- have used it a little with ms access and even...

Hi, Sorry for cross posting. i didn't realize this forum existed before i posted in the ms vc++ forum. I would like to learn COM. Was wondering if anyone knows of any good online free tutorials. I'm broke, so i don't want to buy a book! I have a project coming up where i need to know COM and i...

Hello, I would like to learn COM. Was wondering if anyone knows of any good online free tutorials. I'm broke, so i don't want to buy a book! I have a project coming up where i need to know COM and i don't know a thing about it! so will have to start from scratch... will read up on it in the...