TekTeam
06-23-2011, 02:57 AM
Hi,
We are new here, so sorry if this is done in the wrong place but would appreciate some help if possible.
We are creating a sales pitch in powerpoint 2007 which has the ability to quote for services based on predefined figures held in hidden texboxes.
The data is setup for example in a 3 by 3 grid although each field is a seperate texbox.
If you can understand what we have done here there are essentially three rows and three columns.
We have successfully created a set of strings which pull 3 variables out and create the object name for one of the texboxes depending on what questions were selected previously in the sales pitch.
the first variable is the slide var1(slidenumber). there are a couple of these 3 x 3 grids for example on different slides. the second variable creates the column in that grid var2(columnA,B or C) and finally the third is the row number var3(row1,2 or 3)
The final string would look something like this:
slide1.A1
where A1 on slide 1 is a texbox within a 3 x 3 grid.
Now problem we have is that we need this string to be displayed in another textbox, essentially the quote price box and for it to be the value within the text box A1 on slide 1.
But the code errors on the last string which is the bit that pulls all three together to make the reference but when you run the slideshow it errors saying that strTableCell is an invalid identifier (I have put asterix around this bit in the code example below)
Any help with this appreciated.
Private Sub btnQuote_Click()
Dim strSlideName As String
Dim strSlideColumn As String
Dim strSlideRow As String
Dim strTableCell As String
strSlideName = Slide5.EntitySlideValue.Value
strSlideColumn = Slide5.TurnoverColumnValue.Value
strSlideRow = Slide5.RecordsRowValue.Value
strTableCell = strSlideName & "." & strSlideColumn & strSlideRow
Me.quoteTotal.Value = *strTableCell*.Value
End Sub
thanks in advance,
Chris
We are new here, so sorry if this is done in the wrong place but would appreciate some help if possible.
We are creating a sales pitch in powerpoint 2007 which has the ability to quote for services based on predefined figures held in hidden texboxes.
The data is setup for example in a 3 by 3 grid although each field is a seperate texbox.
If you can understand what we have done here there are essentially three rows and three columns.
We have successfully created a set of strings which pull 3 variables out and create the object name for one of the texboxes depending on what questions were selected previously in the sales pitch.
the first variable is the slide var1(slidenumber). there are a couple of these 3 x 3 grids for example on different slides. the second variable creates the column in that grid var2(columnA,B or C) and finally the third is the row number var3(row1,2 or 3)
The final string would look something like this:
slide1.A1
where A1 on slide 1 is a texbox within a 3 x 3 grid.
Now problem we have is that we need this string to be displayed in another textbox, essentially the quote price box and for it to be the value within the text box A1 on slide 1.
But the code errors on the last string which is the bit that pulls all three together to make the reference but when you run the slideshow it errors saying that strTableCell is an invalid identifier (I have put asterix around this bit in the code example below)
Any help with this appreciated.
Private Sub btnQuote_Click()
Dim strSlideName As String
Dim strSlideColumn As String
Dim strSlideRow As String
Dim strTableCell As String
strSlideName = Slide5.EntitySlideValue.Value
strSlideColumn = Slide5.TurnoverColumnValue.Value
strSlideRow = Slide5.RecordsRowValue.Value
strTableCell = strSlideName & "." & strSlideColumn & strSlideRow
Me.quoteTotal.Value = *strTableCell*.Value
End Sub
thanks in advance,
Chris