PC Review


Reply
Thread Tools Rate Thread

Adding scroll bars

 
 
=?Utf-8?B?TWFyY3VzQQ==?=
Guest
Posts: n/a
 
      13th Apr 2007
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding scroll bars to cells in a table =?Utf-8?B?c3VzaWVx?= Microsoft Excel Programming 1 26th Jan 2007 11:03 PM
Using a div with scroll bars - can we get the scroll bars on the left instead of the right side? UJ Microsoft ASP .NET 1 1st Nov 2006 09:32 PM
adding scroll bars to a chart news2 Microsoft Excel Charting 4 5th Oct 2005 01:27 AM
Adding scroll and/or zoom bars to Charts =?Utf-8?B?Sm9uY3Jpcw==?= Microsoft Excel Misc 3 14th Mar 2004 04:00 AM
Help! Scroll Bars Scroll Down More Than One Page Shelly Faulk Windows XP General 1 23rd Nov 2003 05:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:20 AM.