Search : in
By :

VBA code in a excel form

Last answer on Jul 15, 2009 12:57:59 pm BST Thur_Hoff, on Jun 6, 2009 4:29:54 pm BST 
 Report this message to moderators

Hi,

I made an Excel form for colleagues to enter data in a sheet in rows.
I made a second form on wich other colleagues need to find a 6 digit number(order number) from that data base and than add the status in 2 or 3 empty cells in the same row as were the order number is. More over they need some text boxes in this form that fill automaticaly be filled with data in that same row as were the order number is to let them change the status.


I am not an expert in VBA and Excel Forms but do have a lot of patients :-)

Kind regards

thur

\

Configuration: Windows XP Internet Explorer 6.0

Best answers for « VBA code in a excel form » in :
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Adding a VBA CommandButton with its respective the code ShowAdding a VBA CommandButton with its respective the code Paste these two sub in a general module (Module1 for example). Sub CreateButton() Dim Obj As Object Dim Code As String Sheets("Sheet1").Select 'create button ...
VBA: Finding Hdc in an Excel worksheet or UserForm ShowVBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
Download Unit Converter for Excel ShowIt is not always necessary to use an expensive or sophisticated program or to convert measurement units. It is sometimes enough to use Excel worksheet by only adding a plug-in. Unit Converter for Excel is one of Microsoft Excel plug-in which can...
Download Access MDE Unlocker Show
Download XLS (Excel) to DBF Converter ShowDescription The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...
Hyperlinks ShowIntroduction to anchors Hypertext links or hyperlinks (anchors) are HTML elements that, when clicked on, enable readers to visit a new address. Hyperlinked text is underlined by default. Hyperlinks are what connect web pages to one another. They...
Ask your question Reply

1

 VBAhelp_Needed, on Jul 15, 2009 12:57:59 pm BST
  • +5

Hi,

This is the first time I'm trying to create a form in Excel. I read your message and I'm trying to do the same - creating a form for colleagues to enter data which goes into rows in a spreadsheet. I would also like to allow them to search for the data, edit previous records etc.

Would it be ok for you to share your code with me?

Thanks very much in advance.

Regards,
kC

   
Reply to VBAhelp_Needed
Ask your question Reply
They need your help