Anthony's VBA Forum
Where the knowledge is shared
Menu
Home Page
Forum Index
FAQ
Memberlist
Usergroups
Register
Profile
Messages
Login/Out
Quick Search
Advanced Search
Links
Consulting
Products
Who's Online
[
Administrator
]
[
Moderator
]
How to access textbox values from excel function
Anthony's VBA Forum Index
->
General Excel VBA
View previous topic
::
View next topic
Author
Message
dencur
Joined: 08 Jan 2006
Posts: 1
Posted: Sun Jan 08, 2006 4:21 pm
Post subject: How to access textbox values from excel function
I have created textbox1 on an excel spreadsheet and placed a number in it. I have created a function to try and get that number:
Public Function GetValue(obj as Object)
dim x as string
Getvalue = obj.value
End Function
Then in an excel cell:
=GetValue(TextBox1)
I can't get this to work, has anybody done this?
Back to top
Data
Moderator
Joined: 06 Oct 2004
Posts: 33
Location: NY
Posted: Wed Feb 01, 2006 12:29 pm
Post subject:
To call the textbox value:
Use a similar code as the following:
Worksheets("Sheet1").TextBox1.Value
_________________
Data
Knowledge is Power
Back to top
Display posts from previous:
All Posts
1 Day
7 Days
2 Weeks
1 Month
3 Months
6 Months
1 Year
Oldest First
Newest First
Anthony's VBA Forum Index
->
General Excel VBA
All times are GMT - 4 Hours
Page
1
of
1
Jump to:
Select a forum
Excel VBA
----------------
General Excel VBA
VBA on Finance and Investment
----------------
Option Pricing Models
Portfoilio Optimization
Other Finance Topics
VBA on Statistics
----------------
Probability Distributions
Monte Carlo Simulation
Regression Analysis
Announcement
----------------
Updated News
You
cannot
post new topics in this forum
You
cannot
reply to topics in this forum
You
cannot
edit your posts in this forum
You
cannot
delete your posts in this forum
You
cannot
vote in polls in this forum
Powered by
phpBB
© 2001, 2002 phpBB Group