Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Select row by first cell's contents, then past in values.

OK, I'll try and lay it out really smooth for understanding...

What I want is to have a code that checks down the first column on a
sheet for a specific value, call it PLAYER, and then when it finds
that value, it copies the text from some TextBoxes into the cells in
that row.

I don't know the right code for it but i imagine that it goes
something like this:

Dim Player As Object

Set Player = ComboBox1.Text

Check Range(A:A) For "Player"
Then when you find "Player",
the cell in the same row, but the next column across = TextBox1.text,

the cell in the same row, but the next column across from that =
TextBox2.text,
the cell in the same row, but the next column across from that =
TextBox3.text,


any help you can offer would me massively appreciated.

Ben

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Select row by first cell's contents, then past in values.



very roughly:

do
x=x+1
if worksheets("sheet1").cells(x,1).value="" then exit do
if worksheets("sheet1").cells(x,1).value="Player" then _
worksheets("sheet1").cells(x,2).value=ComboBox1.Te xt :
worksheets("sheet1").cells(x,3).value=ComboBox2.Te xt
loop


should work after you will adjust for your needs

*** Sent via Developersdex http://www.developersdex.com ***
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
Using cell's contents as an index to a row ... ? Mac Excel Worksheet Functions 1 February 14th 09 12:07 AM
link to a cell's contents John Bundy Excel Worksheet Functions 1 November 30th 06 09:43 PM
Can I select a range based on the cell's contents? [email protected] Excel Programming 1 July 29th 05 11:08 AM
Rotate a box with a cell's contents Circe Excel Discussion (Misc queries) 6 February 3rd 05 11:45 PM
macro to use a cell's contents as it's name Stephen Simons Excel Programming 2 June 11th 04 08:49 AM


All times are GMT +1. The time now is 03:23 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"