INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

link text box to excel sheet

link text box to excel sheet

(OP)
dear experts ,

i want to link text box with cell in order to make the cell read the numerical values from the text box to use this value in the sheet equations,
thanks in advance

RE: link text box to excel sheet

Hi,

Are you putting a UserForm between the user and the sheet in Excel? If you need that level of control, then in my opinion, why use Excel? Use Access, for instance, where the user really ought not be messing in the data. But Excel is designed for users to interact directly with the data with a limited amount of interference.

So why can't the user enter the values in individual cells that are used in your equation?

If you need those cells to be isolated from the equation, then use a button with a macro assigned to put the values into the equation on command.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: link text box to excel sheet

I don't entirely agree with Skip. I tend to use data entry directly on the spreadsheet myself (in fact I use forms so rarely I had to do a search to remind myself how they work), but if you want to use a data entry form, that doesn't mean you should be using Access. In my opinion setting up an engineering application in Excel is way easier than using any database program, especially if you are not familiar with the other programs.

The link below seems to cover the procedure pretty well:
http://www.techrepublic.com/article/pro-tip-add-a-...

Alternatively you could set up the form directly on the spreadsheet using formatting and cell protection.




Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: link text box to excel sheet

(OP)
thanks guys for your response :) ,
but what i mean is link text box in excel sheet to specific cell in the same sheet,because i have complicated geometry in the excel sheet and i intend to but the text box at each side of that shape so the user can easily write the value without any confusion and i want to link those text boxes with excel sheet cells to use them in the equations
i try this code but i didn't work

Sub Try()
Range(A1).Value = ActiveSheet.TextBoxes("TextBox1").Value
End Sub

so any suggestions for this issue!!!
thanks

RE: link text box to excel sheet

You need the Text property, not value:

Sub GetText()
[A1] = ActiveSheet.TextBoxes("TextBox 1").Text
End Sub

or

Function GetTextFunc(TxtBoxName)
GetTextFunc = ActiveSheet.TextBoxes(TxtBoxName).Text
End Function

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: link text box to excel sheet

(OP)
thanks a lot[smile]

IDS for your help

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close