Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve enterd with userform
Hello Everybody!!
I desperately need your help. I have been working with this project for weeks and can not figure it out. I bought books looked on the internet and unable to find what I need, So I am asking for your help. I have created UserForm with approximately 20 entries, ie:, File#, Name, Address€¦€¦, this works fine at entering the info. My problem is, that I would like to retrieve the same data entered by File# (which is unique), by name, or by other unique info, and to see it (if possible) in the same Userform that I entered this data. All the data entered are in rows, so all the info need for a File# are in this row. Can anyone PLEASE help me with a code to retrieve this info. Raul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve enterd with userform
post the code you already have behind the form - this will give us all better
idea what you are trying to do. -- jb "Raul1960" wrote: Hello Everybody!! I desperately need your help. I have been working with this project for weeks and can not figure it out. I bought books looked on the internet and unable to find what I need, So I am asking for your help. I have created UserForm with approximately 20 entries, ie:, File#, Name, Address€¦€¦, this works fine at entering the info. My problem is, that I would like to retrieve the same data entered by File# (which is unique), by name, or by other unique info, and to see it (if possible) in the same Userform that I entered this data. All the data entered are in rows, so all the info need for a File# are in this row. Can anyone PLEASE help me with a code to retrieve this info. Raul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve enterd with userform
i imagine that the data is on a worksheet and in a table
use MATCH() to get the row number that corresponds to the item, then you can use offset to get the other bits. without seeing your code, this is difficult I'll demonstrate. Assume a table at A1. A is the colun with the file# and there are n columns I'll assume that your userform has a text box (txtFieNum) holding th efile# you want This code will be in the userforms code sheet WITH Worksheets("sheet1") ' get the row myRow = WorksheetFunction.Match(txtFileNum, .Range("A:A"),False) ' note - raises an error if not found, so yuo may need to handle it 'now populate the userform controls... for colIndex = 2 to n cntrl(index) = .Cells(myRow, colIndex) next ' END WITH the for...next you can replace by directly codeing txtbox1 = .Cells(myrow,2) txtbox2 = .Cells(myrow,3) note the . we're in the worksheet object, so the . indicates a method/property of this sheet object. Leave off the .'s can lead to interesting stuff "Raul1960" wrote: Hello Everybody!! I desperately need your help. I have been working with this project for weeks and can not figure it out. I bought books looked on the internet and unable to find what I need, So I am asking for your help. I have created UserForm with approximately 20 entries, ie:, File#, Name, Address€¦€¦, this works fine at entering the info. My problem is, that I would like to retrieve the same data entered by File# (which is unique), by name, or by other unique info, and to see it (if possible) in the same Userform that I entered this data. All the data entered are in rows, so all the info need for a File# are in this row. Can anyone PLEASE help me with a code to retrieve this info. Raul |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve enterd with userform
the best way to solve all these problems in Excel, you use some network
software. ExcelFIX recommend, I use and I Excel file recovery tools ( http://www.excelfix.com) Raul1960 wrote: Hello Everybody!! I desperately need your help. I have been working with this project for weeks and can not figure it out. I bought books looked on the internet and unable to find what I need, So I am asking for your help. I have created UserForm with approximately 20 entries, ie:, File#, Name, Address€¦€¦, this works fine at entering the info. My problem is, that I would like to retrieve the same data entered by File# (which is unique), by name, or by other unique info, and to see it (if possible) in the same Userform that I entered this data. All the data entered are in rows, so all the info need for a File# are in this row. Can anyone PLEASE help me with a code to retrieve this info. Raul -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can i set a cell to alarm if a date isnt enterd before a set date | Excel Worksheet Functions | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
How do I copy only values of cells when they are enterd? | Excel Worksheet Functions | |||
Would like to retrieve data from spreadsheet to userform | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming |