If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > Visual Basic > help making a command button for search row, column

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-05-10, 13:20
fsp216 fsp216 is offline
Registered User
 
Join Date: Apr 2010
Posts: 3
help making a command button for search row, column

Hola, no tengo demasiada experiencia en visual basic podrian ayudarme a realizar un boton de busqueda?
Les comento lo que necesito:

En la hoja1 tengo 8 filas (a,b,c,d,e,f,Nēc y Val)

Cree 3 textbox:
Textbox1= debo ingresar un dato numerico para que los busque unicamente en la fila "val"
Textbox2= ingresar un dato que debe ser una de las filas a,b,c,d,e o f.
Textbox3= debe ser igual a el resultado de la interseccion de el textbox1 y el textbox2 * la celda k4 de la hoja2.

Espero haber sido explicito en la consulta.
Muchas gracias
Reply With Quote
  #2 (permalink)  
Old 04-05-10, 16:25
loquin loquin is offline
Super Moderator
 
Join Date: Jun 2004
Location: Arizona, USA
Posts: 1,797
intente esto
__________________
Lou
使大吃一惊
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Reply With Quote
  #3 (permalink)  
Old 04-05-10, 17:36
fsp216 fsp216 is offline
Registered User
 
Join Date: Apr 2010
Posts: 3
I can`t read your reply, please repost this.
Best regards
Reply With Quote
  #4 (permalink)  
Old 04-05-10, 18:22
fsp216 fsp216 is offline
Registered User
 
Join Date: Apr 2010
Posts: 3
Hello, I do not have too much experience in visual BASIC. We can to help me to realise a button search?
Them comment which I need: In Sheet1 I have 8 rows (a, b, c, d, e, f, Nºc and Val) Textbox creates 3:
Textbox1= I must enter a numerical data so that it unique looks for in the row " h3; h1500"
Textbox2= to enter a data that must be one of the rows a, b, c, d, e or f.
Textbox3= must be equal to the result of the intersection of textbox1 and textbox2 * the cell k4 of Sheet2.
I hope to have been explicit in the consultation. Thank you very much
Reply With Quote
Reply

Tags
botton, command button, search command

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 On