×
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!
  • Students Click Here

*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.

Students Click Here

Jobs

Put a formula in another cell

Put a formula in another cell

Put a formula in another cell

(OP)
Hi,
Is there a way to put a formula (or number) from a formula/function in another cell?
eg. a function in cell A1 produce a formula in cell B1.

Thanks

RE: Put a formula in another cell

Just use '=A1' (without the quotes) in B1

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

UK steam enthusiasts: www.essexsteam.co.uk

RE: Put a formula in another cell

(OP)
:)
I want to do that without putting anything in B1.

RE: Put a formula in another cell

I don't understand the question.

Quote (first_post):

...a function in cell A1 produce a formula in cell B1

Quote (second_post):

I want to do that without putting anything in B1.
Could you clarify what you want to calculate and what you want to see. If you just want to hide something then use Format|Cells|protection and check Hidden and Locked, then Use Format|Cells|Font and set the colour to the same as the cell background

Sorry I seem to be a bit dense today

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

UK steam enthusiasts: www.essexsteam.co.uk

RE: Put a formula in another cell

You place the method in VBA such as the following:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.AddressLocal = "$A$1" Then
          Target.Formula = [B1] * [C1]
        End If
End Sub

RE: Put a formula in another cell

And me being "dense" too - what's the point of all this - why not just put the formula in cell B1?

RE: Put a formula in another cell

FalsePrecision,
The method I showed utilizing VBA for the equation is a method I use for calculation spreadsheets I sell on the net.  Excel is not a "secure" environment.  

For normal use - I agree its not worth the trouble.

RE: Put a formula in another cell

In what way is VBA more secure than the spreadsheet it lives in?

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

UK steam enthusiasts: www.essexsteam.co.uk

RE: Put a formula in another cell

johnwm,
VBA is tougher to break when protected, where Excel's standard protection scheme at the sheet level can worked around in seconds with programs readily available on the web.   

RE: Put a formula in another cell

Excel's "protection....can worked around in seconds"

VBA's vastly improve protection scheme, on the other hand, may require almost an entire minute to bypass.

RE: Put a formula in another cell

VE- please inform how it can be done.

RE: Put a formula in another cell

When I made that posting, it was intended to be a general comment on the essential uselessness of such 'protection' schemes.  Upon further Googleing, I find that my assumption is correct even in this specific case.

I'm not going to violate the US DMCA by providing any specifics, but bypasses are readily available (just as I assumed they would be).  Google it.

To be honest, it looks like it might actually take about 10 minutes (including download time by dial-up).

RE: Put a formula in another cell

(OP)
Thanks Psafety.

RE: Put a formula in another cell

psafety,
My question was rhetorical - there is no realistic protection in a standard Excel spreadsheet, whether in code or on the sheet. If you want any reasonable level of protection for your intellectual property you need a fully compiled application.

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

UK steam enthusiasts: www.essexsteam.co.uk

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