Adding scroll bars

M

MarcusA

I enter data into three different cells. I use a macro to append this data to
a merged cell. Is it possible to add a scroll bar to a merged cell? I can
add the scroll bar but cannot scroll through the data. Here is the macro
I've assigned to a button to append to the merged cell:

Sub test2()
Dim fname As String, lname As String, entry As String, _
comments As String, comments2 As String
ActiveSheet.Unprotect Password:="edison"
fname = [d22].Value
lname = [i22].Value
entry = [d54].Value
comments = [d32].Value
..Value = Now
comments2 = comments & entry & " " & fname & " " & lname & " " & Date & "
--->"
[d32].Value = comments2
End Sub

Is there a way to use a list/combo box to accomplish this? I also need to
add a "yes/no" question to the macro before appending the data and a time
stamp to the data which remains static.

Thanks
 

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