-
March 29th, 2012, 09:35 AM
#1
Help me in adding Entries in Excel using VBA
I have 3 text boxes with a command button. My request is that after i had entered the text in the text boxes and when the command button is clicked The entries should be added to A1,A2,A3 respectively
and the form should appear again and when i enter the text and click the command button the text should be added to B1,B2,B3 respectively....
Thank you
Waiting for your reply....
-
March 29th, 2012, 02:27 PM
#2
Re: Help me in adding Entries in Excel using VBA
We can help you AFTER you try it yourself. IF you get stuck, post the code, USING TAGS, and we'll help with specifics. We don't do homework.
Code:
' Code comments
' like this
-
March 29th, 2012, 09:19 PM
#3
Re: Help me in adding Entries in Excel using VBA
-
March 30th, 2012, 02:32 AM
#4
Re: Help me in adding Entries in Excel using VBA
Public Col%
Private Sub Command_Click()
...
Col=Col+1
wdat.Cells(1, Col).Value = Text1.Text
wdat.Cells(2, Col).Value = Text2.Text
wdat.Cells(3, Col).Value = Text3.Text
...
End Sub
-
March 30th, 2012, 09:49 AM
#5
Re: Help me in adding Entries in Excel using VBA
Ever READ anybody else's post? How about using CODE TAGS, so that others do the same thing?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|