I've seen lists (usually on a spreadsheet) of a form with its name and properties and the names and properties of all the objects in that form. I assume there is an easier way than copy and paste to get such a list! What is it?
Thanks
Printable View
I've seen lists (usually on a spreadsheet) of a form with its name and properties and the names and properties of all the objects in that form. I assume there is an easier way than copy and paste to get such a list! What is it?
Thanks
I've got no idea how to detect a list of properties, but the names of objects should be fairly easy:
If it doesn't work, try changing Me to the name of the form.Code:Dim varControl as Variant
For Each varControl in Me.Controls
MsgBox varControl.Name
Next varControl
That wasn't quite what I had in mind although it could also be useful. See attached file (I didn't create it) for an example of the sort of thing I want. (A quick way of converting the data back to a form would also be handy.)
I'm afraid I have no idea what you want... that doesn't seem to have anything to do with the question you asked.
i looked at the form, there is nothing in that in relation to your original question,
if you want to put all the details of the forms controls etc
into a spreadsheet, just open the .frm for input as if it was a .txt and fill a rangeCode:Begin VB.Form frmInvoice
BackColor = &H00808000&
Caption = "Form1"
ClientHeight = 9150
ClientLeft = 165
ClientTop = 855
ClientWidth = 9645
LinkTopic = "Form1"
ScaleHeight = 9150
ScaleWidth = 9645
StartUpPosition = 3 'Windows Default
Begin VB.CommandButton cmdClear
Cancel = -1 'True
Caption = "CLEAR"
Height = 495
Left = 7200
TabIndex = 9
Top = 6360
Width = 2055
End
Begin VB.CommandButton cmdExit
Caption = "EXIT"
Default = -1 'True
Height = 495
Left = 7200
TabIndex = 10
Top = 7200
Width = 2055
End
Ah, I fiddled around a bit more and discovered that the answer to my problem was File > Export File. Sometimes the solution to a problem is asking the right question.