LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default Little more advice on this code

Hi all Dave Peterson helped me by writing this code but I need it to do a
little more and I cant seemto work it out.

What the code below does isshows the meeting that are coming up and copies
the information to another worksheet which I will use another way. But at
the moment it only copies the first cell.

The list's rowsource is a2:e65536 so I probably need to have the code copy
the whole line.

Any ideas would be appreciated.

Here is the code
Private Sub CommandButton1_Click()
Dim destCell As Range

With Worksheets("Popup")
Set destCell = .Columns.End(xlUp).Offset(1, 0)
End With

With ListBox1
If .ListIndex -1 Then
destCell.Value = .List(.ListIndex)
End If
End With
Unload Me
messagebox.Show

End Sub
Thanks again

Greg


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Little more advice on this code Greg B Excel Discussion (Misc queries) 3 September 3rd 05 05:31 AM
Advice, help on code using winapi and month-calendar-object of Comctl32.dll Johan De Schutter Excel Programming 0 November 19th 04 11:36 AM
advice on improving code PC[_3_] Excel Programming 2 April 6th 04 11:37 AM
Code advice please... BruceJ[_2_] Excel Programming 1 November 13th 03 06:44 PM
Need advice and code help with working with *.dbf files in Excel 97 TBA[_2_] Excel Programming 1 September 8th 03 09:14 AM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"