Dynamic Changes in Power Point

B

balajimylar

Is is possible that I put in 3 Text Boxes (A,B,C) in a Slide & assign a
formula to the box A=(B+C). When I change values in B & C, A should change
automatically. If this can be done Please let me know the procedure for
doing this.
 
A

Andy Pope

Hi,
Maybe I'm not understanding the question but, add 3 textboxes from the
Control toolbox. Add the following code to the Change events of boxes 1
and 2.

Run the slide show and enter some numeric values in textboxes 1 and 2.

Private Sub TextBox1_Change()

If IsNumeric(TextBox1.Text) Then
If IsNumeric(TextBox2.Text) Then
TextBox3.Text = CDbl(TextBox1.Text) + CDbl(TextBox2.Text)
End If
End If

End Sub
Private Sub TextBox2_Change()

If IsNumeric(TextBox1.Text) Then
If IsNumeric(TextBox2.Text) Then
TextBox3.Text = CDbl(TextBox1.Text) + CDbl(TextBox2.Text)
End If
End If

End Sub

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top