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:
e = 152 g = 400 For i = 0 To UBound(resultString) ' .Checkboxes.Add(g, e, 80, 10).Text = d Set chk = .Checkboxes.Add(g, e, 80, 10) chk.Text = d chk.Name = "Q" & h & "chkbox" & chkbox & "Ans" & An .Cells(k, 25).Formula = chkbox g = g + 50 chkbox = chkbox + 1 Next End If e = e + 12.5
_________
| |
| L a b e l |
|________|
| X | Y |
|---------|
| 1 | 2 |
|---------|
| 3 | 4 |
-----------
Astro




Reply With Quote