Recent content by Jofx

Is it possible to rename a set of bookmarks with vba script ? ex: my doc contains several bookmarks like: [BMK_1] [BMK_2] [BMK_3] I'd like to rename them to: [NEW_BMK_1] [NEW_BMK_2] [NEW_BMK_3] without deleting and inserting new bookmarks Thanks

Mike, I used your code and encounter a bug when closing and re-open XL. I run the following sample, save the sheet, close XL, re-open it, re-run the test, and a error message happens (#9) When I just close the sheet without closing XL, no error happens. Any idea ? Thanks in advance Jofx...

Thanks a lot Mike, it looks like simple. Jofx

May VBA code creates a new sheet at runtime inside an XL workbook. I 'd like to assign a event procedure to that sheet (ex: Sub Worksheet_Activate) dynamically. Is it possible ? Thanks Jofx

Thanks Geoff and Loomah I've have to try it now.

Hi, I'm looking for a Excel VBA code to delete all identical rows in a range (keeping unique rows). ex: Col A A B B C D D D should give: Col A A C Any idea ? Thanks

You are right. It works fine to me now I just wanted to replace specific name "Textbox1" by a generic in the beforeupdate proc: "Userform1.MultiPage1.Pages(Userform1.MultiPage1.Value).ActiveControl.name" it didn't work because the (userform1.multipage.value)represents the current active page...

Microsoft Support: MultiPage control Use a MultiPage control to work with a lot of information that can be sorted into several categories. A MultiPage control is made up of one or more Page objects that each contain a different set of controls. You can set the active page programmatically by...

I come back to my first post: My textbox is inside a multipage. When I put a wrong value in the textbox1 and JUST AFTER click on a other page of the multipages container, the beforeupdate event is not started. in that case, your first tip : .............. Private Sub TextBox1_BeforeUpdate(ByVal...

Thanks bclt, it's working fine in addition, I'd like now 2 things:- - add a message when textbox value is wrong - user can leave the textbox with an empty value (and not necessary a numeric value, i.e 0) Thanks a lot Jofx

HI, I would like to validate a textbox value (numeric). The textbox is inside the first page of a 2 pages multipage in a userform. I did use a standard validation process in this case: "beforeupdate" event on textbox which is calling a procedure But, the point is: when you write a wrong value...

I just tried : Sub textboxName_AfterUpdate() msgbox Me.activecontrol.name end --> MultiPage1

Thanks Ken I've tried your tip but it doesn't work. The activecontrol gives the name of a multipage containing textboxes. Any other idea ?

I would like to get the name of a texbox after this textbox has been updated. something like: Sub textboxName_AfterUpdate() msgbox "The name of the updated textbox" end Thanks

I'm testing Filemaker pro 7 and I'm beginner. Is it possible to do the following : All records of a first table (Table A) are displayed in a layout as a list of rows. By clicking on a icon displayed at the beginning of all rows, I'd like to launch a other layout to display all recors of a second...