form ...

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
form ...

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

May 2nd, 2007, 10:10 AM

afroxav

afroxav is offline

Registered User

Join Date: May 2007

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Default

form ...

I have a form and I'd like to make the value that I enter in a textbox to appear in a cell when I click ok

Old

May 3rd, 2007, 12:14 AM

Shasur

Shasur is offline

Friend of Wrox

Join Date: Sep 2005

Posts: 812

Thanks: 1

Thanked 53 Times in 49 Posts

Default

Private Sub cmdOK_Click()

' You can use either of these

Cells(1, 1).Value = TextBox1.Text

Range("A2").Value = TextBox1.Text
End Sub

Cheers
Shasur

http://www.vbadud.blogspot.com

Old

May 3rd, 2007, 06:30 AM

afroxav

afroxav is offline

Registered User

Join Date: May 2007

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to set a form as startup form in vb.net 2.0	mallikalapati	.NET Framework 2.0	1	February 21st, 2008 09:19 AM
Close all MdiChield form from open one form/Button	salman	.NET Framework 2.0	6	December 10th, 2007 03:21 AM
Firefox Error when Form Floated / Form locks	socoolbrewster	CSS Cascading Style Sheets	5	October 6th, 2007 09:59 PM
How to refresh owner form on closing of child form	akumarp2p	C# 2005	0	December 22nd, 2006 10:27 AM
parent form from child form - urgent plz	netfresher	C#	1	November 8th, 2006 06:59 PM