Hello I am a student taking visual basics and am having a problem understanding how to do something. I am hoping someone can explain this to me better than...
Sherry, are you trying to get to the behind-the-scenes subroutine of the command box? Is so, double click on the command button and it will take you there....
Private Sub Calculate_Click() if option_exit = vbChecked then unload me elseif option_deposit = vbChecked then 'Add amount to your total elseif option_check =...
If we do the assignment for you, then we aren't doing you any favor in the long run. If you would be more specific in your if-then question, we will help you....
Say Guys and Gals, I need to construct a User Form that goes poof in da night from an Excel application. In particular my user form is a simple dialogue box...
DeGance, Anthony
ADEGANCE@...
Oct 2, 2007 3:46 pm
20023
I don't know enough about using VBA with userforms to give you that (the user form) part of the code, but I assume you know how to open the form in code (or...
?Here is what my project has so far for code. We were told to put the if/then calculation under the calculate button. My form has: enterAmtLabel amountTextBox ...
Tim I will look for this book. The book we are using in school is new and its called Programming in Visual Basic.Net 2005 Edition. It's not real helpful in my...
To all, I definitely am not asking you to do my homework. I am 50 and am going to school to learn something I am interested in, I am not trying to waste my...
Actually, overall, your logic is pretty good, and your syntax, while a bit verbose is also rather good. To display your result, simply apply it to the...
Tony, see if this will work for you. I created a user form in Excel. I added two text boxes, called txtBox1 and txtBox2. I created a command button called...
Donald, VB-6 has the UCase() function. Dim UserEntry As String UserEntry = InputBox( The Prompt, The Title, The Default ) If LenB( UserEntry ) <> Num_Zero...
Hi SML139...If you want it, I have a sample checkbook program that may help you in logic and tips on your project. It is in VB6 and is for learning only. The...
Bob
usewillow@...
Oct 3, 2007 4:35 am
20034
Thank you Tim & Bruce, I spent yesterday afternoon trying to work out the stuff found on the link Bruce sent to me. I just failed to achieve escape velocity....
DeGance, Anthony
ADEGANCE@...
Oct 3, 2007 12:47 pm
20035
Private Sub calculateButton_ Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles calculateButton. Click 'Calculate the account balance ...
Hi: I've done lots of macros in Access but this is my first macro in Excel. I'm trying to import a tab delimited text file into a workbook. I'm using some...
Thanks to Steve for his help on the "converting to upper case" question. I have another question. When using a List Box which displays two fields separated by...
Elisa, the problem is in the line: WholeLine -WholeLine & Sep That is not a valid statement. Looking at the code, it appears that you want to add a space at...
Donald here is some code that I have used to search a Combo box it auto completes so you go from A to Z with the tap of a key I can look around if you like and...
Good Morning Don, Not sure I can help, so I'll toss out a few WAGs. 1) When extracting one field from the List Box line make sure that all extra spaces and...
Good Morning Everyone, Some time ago, about 3 or 4 weeks ago me thinks, I was trying to help someone with some code, before I went on my 'walk about', and for...
Good Morning Geoff, It was VB-6, and the person lived in the USA, maybe Canada, but certainly not The_Iraq or The_South-Africa. Wait....., I'm tapping into...
It was I and we have a fix from you and my pea brain that had to do some reading and redesign so please do not go on any more walk abouts I know I will miss...
Hello Steve, Sorry I took so long in replying this time. No promises, but, I may have that particular correspondence on the computer upstairs. If I can find...
Having read Dwight's message, I'll let it go bye? Glad you got your fix Dwight, <G>. Steve has a fairly large garden. I wonder if he gets lost amongst the...
I entered 'I added this' to the places I made changes..maybe this will get you further....I'm guessing you are trying to add a space at the end of each...