Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro which finds data? help?
Hello all. This is probably very simple but I am a complete beginner to VB. I jus tried to record a new macro which would allow the user to click the command button and have the "Find" dialogue box appear. However as I was recording it, once the dialogue box appeared I could not stopthe macro...Excel does not allow it until the dialogue box is closed...which ofcourse is useless to me! I NEED the macro to bring up the Find function. Also I was hoping to create macros which allowed te user to click a button which would then automatically add a new row to the sheet....this row would also be fully bordered. (at present the sheet does not show gridlines, the relevant data is bordered...this is just to give the spreadsheet a more professional look!) Any ideas? -- londonchick ------------------------------------------------------------------------ londonchick's Profile: http://www.excelforum.com/member.php...o&userid=24529 View this thread: http://www.excelforum.com/showthread...hreadid=381895 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MACRO which deletes a row, when it finds a specific number | Excel Discussion (Misc queries) | |||
Macro that Finds the First Value in a range using a Combobox (drop down menu) | Excel Worksheet Functions | |||
Create a macro that finds values then sorts | Excel Worksheet Functions | |||
macro that finds text and keeps only part of it | Excel Discussion (Misc queries) | |||
a macro which finds last cell in a column | Excel Programming |