Newbie Help for College Football Program
I took a few weeks of VB a couple years ago and i have forgot how to set up a text box.
What i'm trying to accomplish is i have made power ratings for every college football team and i want to make a program where you input the names of the two teams playing and the program will spit out the point spread using my power numbers.
I'm wanting it to ask the user which team is the home and away team and then input those responses into two seperate cells. I would then have a value assigned to the team names and have that value inputed next to the team name.
my question is what would this code look like. My memory is giving me this and it is not working.
cells(10,10) = textbox ( "who is the visiting team")
cells(11,10) = textbox ( " who is the home team")
Thanks in advance for any responses
[851 byte] By [
ojom24] at [2007-11-20 0:39:37]
# 1 Re: Newbie Help for College Football Program
...
cells(10,10) = textbox ( "who is the visiting team")
cells(11,10) = textbox ( " who is the home team")..
Cells are used in VB Excel but not in VB. So as we dont do homeworks I would tell you take an easy book for beginners and read it. Then you will be able to do this really easy exercise.
For basically info:
Dim sMyInfo as String
' to write into a Textbox on the form which is named Text1
Text1.Text = "Here comes my Text"
' to get info out od a Textbox
sMyInfo = Text1.Text
And thats all about to know.:D
# 2 Re: Newbie Help for College Football Program
Hm. It seems to me, ojom is writing in VBA for Excel and what he is trying to do is cell(...) = InputBox("Home Team")
WoF at 2007-11-9 19:57:56 >
# 4 Re: Newbie Help for College Football Program
Another VBA/Excel question that i'm having problems with.
My simple little code is working well, but is it possible to create a msgbox that is fluid based on the values in two different cells
EX: Tu 100
Ou 108 -4
msgbox( Ou -4 )
How can i get a msgbox to display what values i have for cells (2,2) and cells(2,4) ?
ojom24 at 2007-11-9 20:00:00 >
# 5 Re: Newbie Help for College Football Program
Just concatenate in the usual way:
MsgBox (Cells(2,2) & " " & Cells(2,3))
This will put a space between the values, but you could use a comma or not have anything between them at all
Dan_H at 2007-11-9 20:01:05 >
