Lazareth
Last Activity: Aug 13 '07, 03:30 AM
Joined: Jan 10 '07
Location: New Zealand
-
VBA Radio Buttons
Hi,
Probabl;y a simple one.
Can someone please help me with the event handler to check which button has been selected. I've tried the following without sucess and nothing in the drop down list sounds suitable...
if xyz.enabled = true
if xyz.triplestae = true
All help appreciated -
thank you.
worked sweet.Leave a comment:
-
if then errors in vba. please help
Hi.
Please help. Still learning...
I am trying to write some code that will assign certain values to a variable based on values from a textbox.
So far I have the following but It doesn't seen to be working.
It should be that if my textbox is
0-3 then the expand value should be 0
4-6 then the expand value should be 1
6 and over then the expand value should be 2
This is... -
save/open textbox as .txt file
Please Help.
I am trying to save the contents of a textbox as a text file on form close and then open the contents of the .txt file in the textbox on form load.
I've tried all the codes I can find on the net unsuccesfully.
I am using VB Basic 2005 Express
Any help Appreciated -
ok. thanks for that.
will give it a try todayLeave a comment:
-
Negative Value in Excel Cell
Hi everyone,
This is probably really simple but you think I can work it out.
I have no experience in VBA but figure it can't be much different to vb.net which I'm ok in.
Alright... I would like to display a message box using VBA whenever the particular value of a cell (C31) is a negative value.
I figured it should be as simple as...
if C31 < 0 then msgbox = " Display Message"... -
Both in some ways.
The data is sourced from an access file and I will then enter (with code) the information from the largest value of a certain field into an array which I can then run certain calculations on
I actually need the top 3 largest values of a certain field entered into different arrays but I figured I would walk before I ranLeave a comment:
-
Largest Variables
Hi,
I need to know how to find the largest variable (integer) of a large amount of variables (integer).
Can anybody help me with the code? -
Thanks for that.
I've never looked at this section of the websiteLeave a comment:
-
It's always strange how the second you ask the question, the answer seems to magically appear.
I found this...
http://www.oreillyschool.com/courses/vbnet/syllabus.php
Has anyone completed this course. If so can you provide some feedback please...Leave a comment:
-
Learning Curve
Hi everyone,
I am new to VB and for the record I absolutelt Love it : )
My question is simple. I live in New Zealand and want to get a jump start on VB. I have tried searching for courses etc specifically on VB and haven't been able to find anything suitable that doesn't include things that I'm not interested in.
Does anyone know of any course I can do wether in person in New Zealand or online that will be... -
Hi Tigger,
Allow emails in your personal file and I will send you the code
CheersLeave a comment:
-
Okay.
Sorry first time I have used the code input, not sure what happened there but basically add
TextBox1.Text = Form1.txtTop.Te xt
on form load event or whatever you're text boxes are calledLeave a comment:
-
Hi,
I'm not sure if this is the easiest way to do this, but you could just access the textbox data directly.
I'm assuming btnnext opens a new form, if so you could do this...
...Code:[size=2][color=#0000ff] Private[/color][/size][size=2] [/size][size=2][color=#0000ff]Sub[/color][/size][size=2] Form2_Load([/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] sender [/size][size=2][color=#0000ff]As[/color][/size][size=2]
Leave a comment:
-
Hi Atran,
Thanks for all your help.
There is no download available at this link.
Do I need to register to this site before I can see it?...Leave a comment:
-
Hi,
I am also wanting to save textbox to a sppecific cell and also read data from excel.
Can you please post solution if you fin one.
CheersLeave a comment:
-
Hi Dokoll,
Thanks for the reply.
I remember seeing something in a tutorial once when I first started learning VB but do you think I can find it again.
I'm just wondering now wether this was VB6 tutorial now that you mention it though as I didn't really know the difference then.
I'll let everyone know if I find anything.Leave a comment:
-
Hi Atran,
That will be great if you can post the code as this is driving me nuts and anything that will overcome this I will appreciate.
Will I need a notepad doc for every checkbox and textbox as their is about 18 checkboxes and 4 text boxes.
I suppose once I see the code I'll know and not a major as I will be happy just to overcome this.
Thanks for your helpLeave a comment:
-
Hi,
I was in your position around 3 months ago.
Visual basic 2005 express edition is availble to be downloaded here...
http://msdn.microsoft.com/vstudio/ex...b/default.aspx
There is lots of tutorials available but the first one I started with was this...
http://www.homeandlearn.co.uk/NET/vbNet.html
Hope this helps...Leave a comment:
No activity results to display
Leave a comment: