Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Pulling data into textbox from spreadsheet

I have a multipage userform that has several drop down boxes that the user
needs to populate (name, month etc..) from that I have text boxes that I
want to populate from another spreadsheet located in the same file.
I need to use an If-then because I want it too look until it finds a match
to the month and then bring in column 3.
I have the textbox set to refresh on _chg action of the dropdown and it is
bringing in the first row but will not find the match. The code is included.

Sub Populate04selldays()
Dim Row As Integer, i As Long, j As Long

Set selling = ThisWorkbook.Sheets("Selling")
TopicCount = Application.WorksheetFunction.CountA(selling.Range ("A:A"))
For Row = 1 To TopicCount
If selling.Cells(Row, 1) = cbmonth.Value Then
tb04selldays.Value = selling.Cells(Row, 3).Value

End If
Next Row
CurrentTopic = 1
End Sub

Any thoughts on how to make this match the month then bring in the data in
another column?


Reply
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
pulling random data from another tab in spreadsheet? davie670 Excel Discussion (Misc queries) 2 March 9th 10 07:56 PM
Pulling data from one spreadsheet to another. Geof Davies Excel Worksheet Functions 1 November 14th 09 01:46 AM
pulling data automatically from one spreadsheet to another [email protected] Excel Worksheet Functions 2 April 7th 07 04:30 AM
Exported data pulling into another spreadsheet Bemidji Excel Discussion (Misc queries) 6 August 8th 06 03:58 PM
Please Help! - Need Help pulling data from one spreadsheet to anot dhwinters Excel Worksheet Functions 1 February 1st 06 09:20 PM


All times are GMT +1. The time now is 01:33 AM.

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

About Us

"It's about Microsoft Excel"