我构建了一个由2列组成的Userform,每个列都有10行文本框。用户输入并保存信息,然后通过单击“保存”将这些信息粘贴到相应的单元格上。为了方便起见,设置默认的Userform_initialise时要使用特定的度量,以便在框架的帮助下隐藏当前未使用的行。问题是当用户完成多行时,保存userform,再次打开它,并尝试添加更多行。)
If Frame1.Height = 60 Then
Us
我有下面的代码,它是一个私有的子程序,它是从Userform3初始化的。在一个公共子程序中显示,据我所知,下面的代码可以工作,但是它在完成后不会返回给公共子。Private Sub UserForm_Initialize().Clear ' clearElseEnd Sub
Private Sub C
Private Sub Calculateseveritybutton_Click()
Set xrg= Worksheets("International CCU Tracker").Range("AB14:AB200")
' replace the").Range("AI" & xcell.Row).V
Stacktrace:
[1] pkgerror(::String) at D:\buildbot\worker\package_win64\build\usr\share\julia\stdlib\v1.3String})(::LibGit2.CachedCredentials) at D:\buildbot\worker\package_win64\build\usr\share\julia\stdlib\v1.3::Array{Pkg.Types.PackageSpec,1}) at D:\buildbot\worker\package_win64\
probe_symlink_creation(::String) at D:\buildbot\worker\package_win64\build\usr\share\julia\std, ::String) at D:\buildbot\worker\package_win64\build\usr\share\julia\stdlib\v1.3] #ensure_all_artifacts_installed at D:\buildbot\worker\package_win64\build\
[1] pkgerror(::String) at /Users/julia/buildbot/worker/package_macos64/build/usr/share/julia/stdlib/v1.3Pkg.Types.PackageSpec,1}) at /Users/julia/buildbot/worker/package_macos64/build/usr/share