Hello there,

I have a list of excel columns to present my questionnaire questions.
note: ms excel 2003.

for eg, i have two columns x and y. at the first cell of each column, a label is required. unfortunately column x and y are to share a single label, i would like to merge the first cell of each column into a single cell in order to accomodate the one particular label.


VB Code:
  1. e = 152
  2. g = 400
  3.  
  4.  For i = 0 To UBound(resultString)
  5.                      '   .Checkboxes.Add(g, e, 80, 10).Text = d
  6.                      
  7.                      
  8.                      Set chk = .Checkboxes.Add(g, e, 80, 10)
  9.                         chk.Text = d
  10.                         chk.Name = "Q" & h & "chkbox" & chkbox & "Ans" & An
  11.                        
  12.                         .Cells(k, 25).Formula = chkbox
  13.                        
  14.                         g = g + 50
  15.                         chkbox = chkbox + 1
  16.  Next
  17.                    
  18.                 End If
  19.                    
  20.                 e = e + 12.5

_________
| |
| L a b e l |
|________|
| X | Y |
|---------|
| 1 | 2 |
|---------|
| 3 | 4 |
-----------


Astro